Increasing DAX Code Readability
DAX is a formula language developed by Microsoft to help data analysts enrich their data set and extract useful information out of raw data. DAX code snippets have nested function…
Using Variables in DAX
Variables are used in DAX to optimize the DAX code. The DAX engine evaluates the variables only once, making the code faster and more readable. Using variables in DAX helps…
Understanding the difference between VALUES(), DISTINCT(), ALL() and ALLNOBLANKROW()
DAX is simple but works on the mantra of “Nothing worth having comes easy”. Anything worthwhile requires effort, so don't give up if you're up against it. This blog will…
All the facts you need to know about fuzzy matching!
Power BI users come from different backgrounds and have their own specific business requirements which they address using their business data. Microsoft Power BI has a large user base in Australia. Power…
Testing table functions in measures
DAX is a formula language used for creating calculated columns, measures, and tables. It is a common misconception that the table functions in DAX are used to create calculated tables…
Exploring Table Joins
Table joins are a common data operation performed by data analytics for joining two or more tables. This may result in an outburst of data which does not carry any…
Solving Data Explosion resulting from CROSSJOIN() in DAX
DAX is Data Analysis Expression language developed by Microsoft to interact with data in various ways. It is a formula language consisting of functions, operations and expressions that return some…
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…