Understanding Key DAX functions in POWER BI
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
Instructor
- 3.7 Instructor Rating
- 273 Reviews
- 52,304 Students
- 2 Courses
"We are very much happy with your training's on Power BI basics and my entire team is working on Power BI with confidence."
"You’re One of the best solution oriented analyst I have ever seen".
"I would look forward to work with you and learn more courses with you "
Above are the messages that I received from my clients during my recent training's given to their company.
Hello, my name is Santosh Pothnak and I am very passionate about sharing my knowledge and skills to students who are always looking to learn! My aim is to help you understand the basic skills on the topics which help you to Perform better at your work place and get more out of what you do.
I'm working with a Top most IT company and over the Past 11 years, I have learnt several skills in my work place as well as at my own interest which will definitely help me to provide you with wonderful learning experience.
I have few technical Certifications with Microsoft:
Microsoft Certified: Data Analyst Associate (DA-100: Analyzing Data with Microsoft Power BI)
Exam 98-381: Introduction to Programming Using Python
Microsoft Certified: Azure Fundamentals
Exam 778: Analyzing and Visualizing Data with Microsoft Power BI
Few of my skills include BusinessObjects Reporting Tools , Power BI Desktop , AzureDevOps , Python Photo Editing tools Adobe Photoshop , Wondershare Filmora Video Editing Tool etc.
And as a Tutor I would like to inform you that each of you are my top most priority. All of my courses are made in such a way that it reaches all kind of audience. And in case if any of my course content is unclear , I request you to send me a message so that I can look into your query and spend one on one time with you in order to clarify your doubts.
Thank you very much for your interest in my courses and in me as an instructor. I look forward to seeing you in one of my lectures very soon.
Best Regards,
Santosh Pothnak
Keep Loving , Spread Happiness