Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi!
So I'm trying to "move" alla previous year metrics one day. For example; 2022-11-18 should be compared to 2021-11-19. I have solved it on a line by line basis but the sum of days doesn't work. I realize that it must be down to my "max"-part of the calculation but can't figure out an alternative to work.
See below example, the total takes the latest date.
Formula looks like this:
Any ideas?
Solved! Go to Solution.
Ok, try this then:
PY =
SUMX (
VALUES ( Table[Date] ),
CALCULATE (
[Sales],
FILTER (
ALL ( 'Date'[Date] ),
'Date'[Date]
= MAX ( OrderData[OrderDate] ) - 364
)
)
)
Proud to be a Super User!
Paul on Linkedin.
Try:
PY with total =
SUMX(VALUES(Table[Date]), [PY Sales])
Proud to be a Super User!
Paul on Linkedin.
Hi! The solution works, but its' not ideal because then I need to create 2 metrics for all PY calculations.
In other words, ideally I would just have 1 metric for PY rather than having to create first the "YTD"* PY calculation and then the sum calculation of that.
*YTD = Max date being last orderdate
Ok, try this then:
PY =
SUMX (
VALUES ( Table[Date] ),
CALCULATE (
[Sales],
FILTER (
ALL ( 'Date'[Date] ),
'Date'[Date]
= MAX ( OrderData[OrderDate] ) - 364
)
)
)
Proud to be a Super User!
Paul on Linkedin.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
110 | |
109 | |
94 | |
61 |
User | Count |
---|---|
171 | |
139 | |
133 | |
103 | |
86 |