Dateadd function returns wrong values

[Anonymous]

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

[Anonymous · Accepted solution]

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]

Hi,

What result do you get when you try this

=CALCULATE(SUM('Extrakt SAA'[Umsatz]);PREVIOUSYEAR(Kalender[Datum]))

[Anonymous]

Hi,

No error message but blank values only.

[Ashish_Mathur]

Hi,

Share the link from where i can download your workbook.

[MattAllington]

Which table is your "year" in the visual coming from?  Is it from your calendar table?

[Anonymous]

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

[Anonymous]

Hi,

Yes it is from the calender table. I tryed to change the realitonsship, sorted the date column but the result did not change.