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
Watch video USING DAX TO SOLVE POWER BI QUESTIONS online without registration, duration hours minute second in high quality. This video was added by user Akerele Oluwasogo (Mr Excel) 01 January 1970, don't forget to share it with your friends and acquaintances, it has been viewed on our site 299 once and liked it 9 people.