Animated Bar Chart Race in Power BI: Visualising Changing Ranks
Table of Contents
Introduction
In data analytics, rankings are never static; regions products, and sales leaders shift a...
Understanding the difference between VALUES(), DISTINCT(), ALL() and ALLNOBLANKROW()
Table of Contents
Introduction
When working with DAX in Microsoft Power BI, functions like VALUES(), DISTINCT(), ALL() an...
Power BI DAX Tutorial: Handling Parent-Child Hierarchies with PATH, PATHITEM, and LOOKUPVALUE
Table of Contents
Introduction
Parent-child hierarchies are common in real-world data models, especially when working wit...
Learn How to Write DAX Queries in DAX Studio Using Query Builder
Table of Contents
Introduction
DAX Studio is one of the most valuable tools for Power BI users who want to understand, te...
TOPN() Function in Power BI: Step-by-Step Guide to Calculating Top 10 Stores
Table of Contents
Introduction
Analyzing your top-performing products is one of the most valuable insights you can extrac...
Power BI DAX Tutorial Analyzing Parent-Child Hierarchies and Sales Using DAX
Table of Contents
Introduction
Parent-child hierarchy is common in business data, such as employee reporting structures, ...
Mixing Table Functions: SUMMARIZE() & FILTER()
Using DAX Summarise and Filter in Power BI
Introduction
In our quest to understand and harness the power of Data Analy...
COUNT(), COUNTROWS(), & DISTINCTCOUNT()
Table of Contents
DAX (Data Analysis Expressions) functions are the backbone of Power BI's powerful data manipulation capabilities. Am...
Getting Started with DAX
DAX studio is an excellent tool to author DAX queries and analyse the performance of Power BI or Power Pivot Data models. It can suppor...
Advanced DAX Studio Scenarios
In our Power BI training in Sydney and Melbourne and other Australian cities, we help our clients to perform the following insightful a...