USING DAX TO SOLVE POWER BI QUESTIONS

POWER BI VIDEO: DAX YOU NEED TO KNOW AS A DATA ANALYST

Getting started with Data Analysis Expressions (DAX) can be intimidating, but becoming knowledgeable in just a few basic functions can help you to unlock many new insights into your data.

While it is easy to create visuals in Power BI or Pivot Charts, we often desire to view data for specific time frames, or with specific filters applied or removed, that we are unable to accomplish with our raw data.

1. CALCULATE
2. FILTER
3. SUMX
4. RELATED
5. TIME INTELLIGENCE FUNCTION(TOTALYTD, TOTALQTD, TOTALMTD)

In this video, I explained how to use DAX to solve some related problems in Power BI

The CALCULATE function evaluates an expression in a context that is modified by specific filters.

CALCULATE(expression, filter1,filter2…)
Let’s say you are now interested in getting profit for France, Germany, Canada

While you could create some piecemeal expressions to accomplish this, you can easily and cleanly accomplish the same thing utilizing the CALCULATE function.

The following example, which uses the CALCULATE function, can accomplish this:

Sum of profit for "France", "Germany", "Canada"

= CALCULATE(SUM('Financials'[Profit]),'Financial'[Country]="France")

The CALCULATE function is one of the most powerful and useful functions in DAX.

It is helpful to think of the CALCULATE function as a supercharged “IF” statement.

A couple of rules apply to the CALCULATE function: The filter parameters cannot reference measures, and expressions cannot use any functions that scan or return a table.

The CALCULATE function is typically used with aggregation functions, and although the filter parameters are optional, at least one is typically used.

Watch the video to learn more

Is the video helpful?

Drop your comment

Do you want to learn Data Analytics using Excel, Power BI and SQL?

Join our December Cohort. It is 5 weeks program

Call us on 08062468296 to register

Choose Lead-Leap Data Analytics School