No sound just video!
1) Open Lab_1 Transformation (Download here: 1drv.ms/u/s!Alvuj-qy-MKIgrZW2...)
2) Create Date Table (Calculated Table)
Date = CALENDARAUTO()
3) Create Claculated Columns
Year = YEAR('Date'[Date])
Month = Month('Date'[Date])
Month name = FORMAT('Date'[Date],"mmm")
CW = WEEKNUM('Date'[Date],1)
Day = DAY('Date'[Date])
4) Connect the Date Table to the existing Datamodel
Sales 'OrderDate' - Date 'Date'
5) Create a clustered column chart (in Visualization pane)
X-Axis (or Axis) - Year
Y-Axis (or Value) - Revenue
6) Create 2 new measures
In the Data pane, beside Sales Table - Click 3 dots
Choose New Measure
PY = CALCULATE(SUM(Sales[Revenue]),SAMEPERIODLASTYEAR('Date'[Date]))
% Growth = DIVIDE(SUM(Sales[Revenue])-[PY],[PY])
7) Change the Visual into Line and Clusterd column chart
Add the PY Measure to the Column y-Axis (or Column Value)
Add the %Growth to Line y-axis (or Line Value)
8) Change the data type of the %Growth Measure
Mark the %Growth Measure (click in the name)
Choose the % in the Header ribbon
19 май 2023
