Understanding Key DAX functions in POWER BI

IEM Daily       October 21, 2021   

This course helps is you to deal with the important DAX functions that are useful in day to day reporting development.

Platform: Udemy
Status: Available
Duration: 3 Hours

Price: $24.99 $0.00

Note: Udemy FREE coupon codes are valid for maximum 3 days only. Look for "Get Coupon" orange button at the end of Description. This post may have affiliate link & we may get small commission if you make a purchase.

Notice for Our Visitors in INDIA:

If Udemy Coupon is 100% OFF but it is not FREE when you go to Udemy Website, please follow the below instructions to make it work. This is mainly affecting visitors that has INDIA as a Country of Residence in their profile in Udemy.

Steps:

1. Use VPN (Virtual Private Network) & Select Another Country like USA.

2. Clear udemy.com website cookies from your browser or You can also use incognito mode or different browser like Opera which has inbuilt VPN.

3. After making a VPN Connection, Create a new Udemy Account.

4. Then go to your desired Course Page & Apply Coupon.

5. If the Coupon is successfully applied, then Continue the process & Enter the VPN Country.

6. Enjoy your Free Course!

What you'll learn

• Key DAX functionalities on the core working of the function itself
• The working of DAX formulas
• Learn the core concepts of Evaluation Context and setting the initial context
• In this course you will learn Important and Advanced topics of DAX functions and Concepts with practical examples.

Requirements

• Basic knowledge on POWER BI and DAX

Description

Course covers different functions that are used in day to day reporting development and is helpful to understand the core concepts of these DAX functions. The videos are precise to topic and no additional information is covered other than the topic itself.

** This is not recommended for you , if you are already good at DAX and understand the core DAX functionality , as this course is designed for who wanted to explore the KEY DAX functions and just getting to learn DAX.

Key Topics Covered in the Course :

· Understanding Context in Power BI

· Evaluation Context or Initial Context in Power BI

· Aggregations or Filter Context in Power BI

· Iterations or Row Context in Power BI

· Understanding Cumulative Sales Calculation

· Understanding Rolling Total Calculation

· Power BI Slicer Selections To Use With Different Measures

· Understanding ALL Function

· Using TOPN Function

· Understanding ALLSELECTED Function

· Understanding LASTNONBLANK Function

· Understanding TREATAS Function

· Difference between USERELATIONSHIP & TREATAS

· Calculating MEDIAN value

· Understanding CALCULATETABLE Function

· How And When To Use PARALLELPERIOD

· Different Ways You Can Use The TOPN Function

· Uses of Iterating Formulas In Power BI

· The Main Difference Between ALL And ALLSELECTED

· Advanced RANKX - Deep Understanding

· How To Use The GROUPBY Function In Power BI

· Dealing With Mulitple IF Statements In Power BI Using DAX

· Dynamically Change Size Of Visual Based On Ranking Selection in Power BI using DAX

· Create Dynamic Visuals Based on Ranking in Power BI using DAX

Who this course is for:

• POWER BI Developers , Power BI Report Builders