Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi
I'm trying to get the sum unit year over year, the calculation is fine for 2018,
However, for 2019 I just want the sum up to Feb 3rd actually, but now the sum will up to end of Feb.
This make the Units YoY% very low at -46.4%
What should I do to get the Unit YoY% up to Feb 3rd?
Thanks in advance,
Simon
Solved! Go to Solution.
Hi,
I think I've got the answer from this link
The PBIX gives me a very good example.
https://community.powerbi.com/t5/Desktop/YTD-last-year-DAX/m-p/108482#M45612
Thanks anyway!
Hi,
I think I've got the answer from this link
The PBIX gives me a very good example.
https://community.powerbi.com/t5/Desktop/YTD-last-year-DAX/m-p/108482#M45612
Thanks anyway!
User | Count |
---|---|
127 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |