The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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 the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
76 | |
65 | |
52 | |
51 |
User | Count |
---|---|
128 | |
117 | |
78 | |
65 | |
63 |