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.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.