Hello,
I've been trying to solve this issue, but w/o success, tehrefore I came here for help.
My main issue is concerning the date differnce in past (year, month etc.) tyo ompare witrh current values.
I have uploaded 2 types of files:
Now, when I try to bring the figures from 2022 to 2023, in case of raw data it works and brings all the correct figures, but in case of defined formula, e.g.: for measure 13" daily - w formula, the dateadd measure brings some different figures. altough the calculations gives the correct daily figures.
I have attached a picture to show exactly how it looks (also the PBI file):
In case of W01 from 2022 w have for measure "13" -> 1373 pcs which both versions calculate corect, but the date add brings different values: 1373 for raw data and 1600 for formula data.
P.S.: same behavior is also if I use SAMEPERIODLASTYEAR measure.
PBI File
Any suggestions?
Many thanks!
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
108 | |
75 | |
66 | |
50 | |
48 |
User | Count |
---|---|
164 | |
87 | |
77 | |
70 | |
67 |