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 Ti...