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.
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.