Digital Ashish

 

Bonus Advanced DAX Challenges

41. Top Customer Name

Top Customer =
TOPN(
1,
VALUES(SalesData[Customer Name]),
[Total Sales],
DESC
)

42. Sales Above Average Flag

Sales Above Average =
IF(
[Total Sales] > [Average Sales],
"Above Average",
"Below Average"
)

43. Dynamic Sales Target Achievement

Target Achievement % =
DIVIDE(
[Total Sales],
500000
)

44. Same Period Last Year Sales

SPLY Sales =
CALCULATE(
[Total Sales],
SAMEPERIODLASTYEAR(SalesData[Date])
)

45. YoY Growth %

YoY Growth % =
DIVIDE(
[Total Sales] - [SPLY Sales],
[SPLY Sales]
)

Final Student Tasks

Dashboard Project Ideas

Project 1 – Sales Dashboard

Create:

  • KPI cards
  • Product sales chart
  • State-wise analysis
  • Monthly trend chart
  • Payment type analysis

Project 2 – Executive Dashboard

Create:

  • Profit analysis
  • Customer segmentation
  • Top products
  • Growth percentage
  • Dynamic filtering

Project 3 – Advanced Analytics Dashboard

Create:

  • Running totals
  • Ranking analysis
  • Time intelligence visuals
  • Forecasting visuals
  • Drill-through reports

Important Learning Topics Covered

✅ Measures ✅ Calculated Columns ✅ Time Intelligence ✅ CALCULATE Function ✅ FILTER Function ✅ ALL & ALLEXCEPT ✅ RANKX ✅ DIVIDE ✅ SWITCH ✅ IF Statements ✅ Dynamic Analysis ✅ Dashboard KPIs

Recommended Practice Order

  1. Basic Aggregations
  2. Calculated Columns
  3. Measures
  4. Filters
  5. Time Intelligence
  6. Ranking Functions
  7. Dynamic Calculations
  8. Dashboard Building
  9. Advanced Analytics

Pro Tip

Always create a separate Date Table in Power BI for better Time Intelligence calculations.

Example:

Date Table = CALENDAR(DATE(2023,1,1), DATE(2025,12,31))

Then mark it as: Modeling → Mark as Date Table

I created a complete Power BI DAX practice guide using your Tech Products Sales dataset. It includes:

  • Basic DAX formulas
  • Calculated columns
  • Intermediate measures
  • Advanced DAX functions
  • Time intelligence formulas
  • Ranking & dynamic analysis
  • Practice challenges
  • Dashboard project ideas
  • Suggested visuals for Power BI

The guide is structured from beginner to advanced level so students can practice step-by-step.

Comments

Post a Comment