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.
MattAllington
Community Champion
Community ChampionWhich table is your "year" in the visual coming from? Is it from your calendar table?
Hi,
Yes it is from the calender table. I tryed to change the realitonsship, sorted the date column but the result did not change.
Thank you, you were right. I have to change my date fields in the slicer it's coming from the sales table.
Thank you again