Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi team
Need your help on this please.
I want to create a mesure to compare same period to 2019. instead of same period last year, I need same period 2019.
Solved! Go to Solution.
@liboyjoseph , if you always was 2019
Y3 =
var _diff = 2019 - maxx(allselected('Date'), 'Date'[Year]) )
//or var _diff = 2019 - year(maxx(allselected('Date'), 'Date'[date]) ))
return
CALCULATE([Total Sales TY],DATEADD('Date'[Date], _diff , YEAR))
@liboyjoseph , if you always was 2019
Y3 =
var _diff = 2019 - maxx(allselected('Date'), 'Date'[Year]) )
//or var _diff = 2019 - year(maxx(allselected('Date'), 'Date'[date]) ))
return
CALCULATE([Total Sales TY],DATEADD('Date'[Date], _diff , YEAR))
Hi, I want to make a measure to compare every last 4 year to 2017, same period. 2017 is my reference year to calculate an evolution for 2018, 2019, 2020 ...
User | Count |
---|---|
42 | |
26 | |
21 | |
16 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
17 | |
15 |