Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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!
Check out the November 2023 Power BI update to learn about new features.