DAX in practice: measures, contexts and filters
SUM or SUMX, CALCULATE, ALL, FILTER, time intelligence, SWITCH: write correct DAX measures in Power BI and Power Pivot.
Access: an e-mail address is enough, you receive a sign-in code. Free modules need no bank card.
What you will be able to do
- Create first DAX measures and get correct totals with SUM or SUMX
- Master aggregations and iterators: MIN, MAX, MINX, MAXX, SUMX over distinct values
- Look up values in DAX with LOOKUPVALUE and RELATED
- Change the filter context with CALCULATE, ALL, ALLSELECTED, FILTER and KEEPFILTERS
- Choose the displayed measure with SWITCH and SELECTEDVALUE, and classify by thresholds
- Compute year-to-date, prior year and moving averages, and drive dynamic filters and titles
Who it is for
Power BI or Power Pivot users who build reports and want reliable totals and filters.
Prerequisites
Able to import data and create a visual in Power BI (“Power BI dashboards step by step” course, foundation modules).
Included
- Video with chapters
- PDF slides
- Marked quiz
- Verifiable certificate
Programme
Fundamentals
- 01First DAX measures and a first dashboard
- 02SUM or SUMX: getting the totals right
Intermediate
- 03SUMX over distinct values: controlling the total
- 04MIN, MAX, MINX, MAXX: aggregates and iterators
- 05LOOKUPVALUE and RELATED: looking up in DAX
- 06CALCULATE: changing the filter context
- 07ALL and ALLSELECTED: fixed total or total by selection
- 08FILTER or KEEPFILTERS: filtering without traps
- 09Fifteen DAX measures explained (Power Pivot, Power BI)
- 10Choosing the measure displayed with SWITCH and SELECTEDVALUE
Advanced
- 11Time intelligence: year to date, prior year and moving average
- 12Dynamic title and thresholds with GENERATESERIES
- 13Dynamic filter: adapting the slicer with SUMMARIZE
- 14Classifying and filtering by thresholds with SWITCH(TRUE())
- 15Field parameters and dynamic change filters
Training a team? Access for several employees, on quotation. admin@axent-consulting.com