Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I want a line chart with a running total of this year, and a separate line of the running total of previous year.
A first issue I encounter is that with below DAX formula, there are 'gaps' in the LY running total (when the running total last year did not change day after day, this happens).
I work with a separate date table...
Eg, on the LY running total, there is a blank value for 08/05/2023, but in 2022 there was a value (the same as the day before)
The next issue is that the line graph of the last year running total is different from the real running total of last year (as seen in the 2022 running total orange line). This probably has something to do with the gaps in the LY running total?
Solved! Go to Solution.
hi @AnFroyman
Here you go,
Step 1
Step 2
Ritesh
Also, don't you think that the other values (non blank), even those are not correct ?
dropbox or google drive link
Please try this DAX
Hi @ribisht17, it now looks like it is presenting the running total of yesterday instead of last year?
hi @AnFroyman
Here you go,
Step 1
Step 2
Ritesh
Glad that it helped!!
🙂
hi @AnFroyman
Have you tried this https://learn.microsoft.com/en-us/dax/sameperiodlastyear-function-dax ?
Regards,
Ritesh
@ribisht17 thanks for your reply. Indeed, the sameperiodlastyear function returns the same behaviour (blanks).
User | Count |
---|---|
103 | |
90 | |
78 | |
72 | |
68 |
User | Count |
---|---|
110 | |
96 | |
95 | |
74 | |
71 |