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;YEAR)).
I have a own table for the calendar (Kalender) which is linked to the sales table(Extrakt SAA). Date coloums in both tables are formated as date. The Kalender table has no gap and includes all dates of the sales table.
The problem is that the formular above returns the same figures in prior year and current year. There is no message error.
For exampel: Year sales sales-last year
2012 1,000 1,000
but prior year was 900???
Maybe someone has an idea what is going wrong?
Thank you in advance
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.
7 Replies
- MattAllington
Community Champion
Which table is your "year" in the visual coming from? Is it from your calendar table?
- Ashish_Mathur
Super User
Hi,
What result do you get when you try this
=CALCULATE(SUM('Extrakt SAA'[Umsatz]);PREVIOUSYEAR(Kalender[Datum]))- Ashish_Mathur
Hi,
Share the link from where i can download your workbook.
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.
