Mixing table functions: ALL() & FILTER()
Mixing table functions: ALL() & FILTER() The usefulness of DAX functions lies in using DAX functions together in a manner where they add value to each other. This blog presents…
Using FILTER() as a Table function
FILTER() is a part of our every Power BI DAX Essentials training. The function derives its functionality after its name. The FILTER() function is used to slice the data based…
Understanding the SUMMARIZE() function In DAX
In our Power BI DAX Essentials course, the instructors focus on coaching Power BI DAX skills based on applicable examples. One of such skills is creating summary tables over the…
Creating summary table for the requested totals
Summary tables are a part of our every Power BI DAX training because they provide a bird-eye’s look at the data. They are created using DAX functions such as SUMMARIZE()…
Two easy ways to create a Bubble map with four simple steps in Power BI Desktop
We’re often asked in our Melbourne Power BI trainings to elaborate on the concept of selecting the best Map visual. So, we started an archive to guide Power BI users…
Using ALL() to Ignore Filters
Our Power BI DAX training covers the table functions in detail because they are widely used for calculating information out of raw data. DISTINCT(), VALUES() and ALL() can given similar…
DISTINCT() vs. VALUES()
Table functions are a category of DAX functions used for calculating tables based on a certain requirement. These table do not exist originally as a part of data model and…
Using VALUES() in Calculated Tables
Learning DAX opens a whole new world Power BI for you. It upskills the user with a skill which is not only limited to Power BI. DAX can be used…
How To Combine Data Using Merge and Append in Power BI Query Editor?
Combining multiple queries in Power Query Editor is a common activity for data preparation. Merge and Append queries are the two types of techniques used for combining queries. Although data…
An overview of Power Apps Studio and Gallery
Microsoft Power Apps platform is increasingly gaining popularity as it does not require any prior app-building knowledge. Power Apps platform has an interface similar to other Microsoft applications which makes…