Welcome to Day 19 of the 21 Days DAX Challenge!

Use code: YouTube20 to get 20% OFF on our full DAX course!
Enroll Now: https://learn.pavanlalwani.com/courses/Microsoft-Power-BI-DAX-686b9f59bd8e322a4efb3109

In today’s challenge, we’re solving a very practical business problem – finding which product category generates the highest revenue in your business using Power BI DAX.

You’ll learn:
How to calculate total sales per category
How to find the maximum revenue using DAX
How to get the category name that matches the highest revenue
How to tweak the formula to find the lowest revenue category too

This insight is powerful for making smarter business decisions like boosting marketing for high-performing categories or improving underperforming ones.

Remember: Mastering DAX takes practice, so keep following the challenge to strengthen your skills!


Timestamps (Summary):
00:00 – Intro & challenge overview
00:14 – Why category-wise revenue matters
00:41 – Steps to solve the problem
03:42 – Finding maximum revenue
04:35 – Getting the category name
05:09 – Finding lowest revenue category
05:37 – Key takeaway & wrap-up

Watch all challenge days here: https://youtube.com/playlist?list=PL6Omre3duO-Nrn_V_qnKEp79dXLolDKU9&si=hS0zlutZShSXwWus
Learn Power BI with me: https://learn.pavanlalwani.com/courses/Power-BI-Specialization-63a05686e4b0a7b1ab4dfc8d