No sound just video!
Based on the last session: • DAX Basics (enjoy learn)
First Open Lab_2 DAX II (1drv.ms/u/s!Alvuj-qy-MKIgstrQ...)
1) First we will create a KPI storage for our Measures!
2) Year to Date with "Quick Measure" and with own Measure:
Revenue YTD =
TOTALYTD(SUM('Sales'[Revenue]), 'Date'[Date].[Date])
3) Yesterday Label in Date Table as claculated Column:
Label Yesterday =
If('Date'[Date]= MAX('Date'[Date]),"Yesterday", FORMAT('Date'[Date], "dd.mm.yy"))
4) Basic Measures for our Data model:
PY = CALCULATE(SUM(Sales[Revenue]),SAMEPERIODLASTYEAR('Date'[Date]))
% Growth = DIVIDE(SUM(Sales[Revenue])-[PY],[PY])
5) KPI Indictor as Color and Icon:
Color Indicator = IF('KPI'[PY]›5000,"green","red")
Icons = IF('KPI'[% Growth]›0,"CircleHigh","CircleLow")
Have Fun!
9 июн 2023