Power BI Self-Paced DAX Intermediate
£120.00 – £5,000.00
In this Power BI DAX self-paced Intermediate training course, which is suitable for experienced Power BI users who are already familiar with DAX fundamentals, delegates will delve deeper into the DAX functional language. The main topics covered are Dynamic Titles; Interacting with the User; Dynamic Formatting; Ranking with DAX; DAX Time Intelligence and Semi-Additive Measures.
Description
In this Power BI self-paced DAX Intermediate Training Course, which is suitable for experienced Power BI users who are already familiar with DAX fundamentals, delegates will delve deeper into the DAX functional language. The main topics covered are Dynamic Titles; Interacting with the User; Dynamic Formatting; Ranking with DAX; DAX Time Intelligence and Semi-Additive Measures.
Our self-paced online courses help users to extend their Power BI skills. These short courses convey important topics via step-by-step demonstration and users are provided with all of the necessary resources to replicate the techniques shown as they learn.
Course Outline
Dynamic Titles
Using the SELECTEDVALUE Function
Nesting the SELECTEDVALUE Function
Using CONCATENATEX with Dynamic Titles
Interacting with the User
The USERNAME Function
Displaying the last refresh date and time
Creating dynamic Accessibility Alt tags
Dynamic Formatting
Creating Measures which Return RAG Colours
Creating Measures which Return Images
Ranking with DAX
The RANKX Function
Ranking Within a Group
Using the TOPN Function
DAX Time Intelligence
Power BI Auto Date/Time Feature
Calendar Tables
Automatic vs Manual Time Intelligence
The TOTALYTD, TOTALQTD and TOTALMTD functions
The SAMEPERIODLASTYEAR Function
Using the DATEADD Function for Maximum Flexibility
The PARALLELPERIOD Function
Calculating Running Totals
Using DATESINPERIOD for MAT and 3MMA
Semi-Additive Measures
What is a Semi-Additive Measure?
Creating a Semi-Additive Measure
Non-Additive Visualization
Additive Visualization
Additional information
Date | Single User, Up to 10 Users, Up to 20 Users, Up to 30 Users, Up to 40 Users, Up to 50 Users, Up to 60 Users, Up to 70 Users, Up to 80 Users, Up to 90 Users, Up to 100 Users |
---|