Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.
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!
User | Count |
---|---|
84 | |
70 | |
68 | |
59 | |
51 |
User | Count |
---|---|
42 | |
41 | |
34 | |
32 | |
31 |