Understanding Key DAX functions in POWER BI

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

4.95 (44 reviews)
Udemy
platform
English
language
Other
category
instructor
Understanding Key DAX functions in POWER BI
10,740
students
3 hours
content
Jan 2024
last update
$54.99
regular price

What you will 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.

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



Content

Understanding Key DAX functions in POWER BI

Introduction
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 D
Create Dynamic Visuals Based on Ranking in Power BI using DAX

Reviews

Lavanya
August 9, 2023
Good n clear explanation by the Trainer. He is explaining the concepts in simple terms n in detail so that anyone can understand. Mr. Santosh Pothnak covered all the important DAX Functions and these are very useful for learning PowerBI. Very informative n useful training. Thank you for the course. It’s very useful and beneficial. I would highly recommend everyone who wants to learn and understand DAX easily .
Mythreyi
August 2, 2023
Very informative course by Santosh. He is teaching in very simple language and easy to understand. He gives us good knowledge of DAX. Thank you Santhosh!!
Vijay
February 21, 2023
This course is very useful.. Santosh sir has explained all the Dax functions in simple terms making us easier to understand.. and he has covered all the important functions used.. I would highly recommend everyone watching the videos and get benefitted. -Sanjana
Moirayee
November 7, 2022
The training was to the point and Mr. Santosh Pothnak was very thorough and detailed in explaining the the concepts. I am very satisfied with the training.
Harshitha
August 11, 2022
I really appreciated this course, very informative each content was explained in in-depth way, easy to understand. guys go for it it's really helpful.
Neha
September 23, 2021
I recently took DAX course and I am very glad that I made the right choice. The DAX course content is just fantastic and very easy to understand. I now feel much more confident working with DAX in Power BI.
Pooja
September 18, 2021
I really liked the course and how in a slow pace he explains the DAX concepts. All we need is some patience to finish all the videos to get clarity. Thanks much
Milton
September 9, 2021
His speaking makes it imposible to understand what he is saying. And the subtitles doesn't help either becasuse most of the time are wrong because even it doesnt understand what he is saying

Coupons

DateDiscountStatus
8/30/2021100% OFF
expired
9/19/2021100% OFF
expired
10/20/2021100% OFF
expired
7/8/2023100% OFF
expired
4/12/2024100% OFF
expired

Charts

Price

Understanding Key DAX functions in POWER BI - Price chart

Rating

Understanding Key DAX functions in POWER BI - Ratings chart

Enrollment distribution

Understanding Key DAX functions in POWER BI - Distribution chart

Related Topics

4258368
udemy ID
8/23/2021
course created date
8/30/2021
course indexed date
Angelcrc Seven
course submited by