Forum Discussion
Dateadd function returns wrong values
Hi, I created a measures with a dateadd function which should return the sales of the prior year. The formular entered is UmsatzVJ = CALCULATE(SUM('Extrakt SAA'[Umsatz]);DATEADD(Kalender[Datum];-1;...
Thank you for you support but I found the error.
In the visuals I selected the date coloumn from the sales table instead of the Kalender table. This means when I select a year in my visual values are filtered to that single year and the values of the prior year are not in the table. I changed the fields and now it's working perfect.
Thank you again for your help.
Ashish_Mathur
Super User
Super UserHi,
What result do you get when you try this
=CALCULATE(SUM('Extrakt SAA'[Umsatz]);PREVIOUSYEAR(Kalender[Datum]))Hi,
No error message but blank values only.
- Ashish_Mathur
Hi,
Share the link from where i can download your workbook.