Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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.
Hi,
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.
Hi,
Share the link from where i can download your workbook.
Which table is your "year" in the visual coming from? Is it from your calendar table?
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
Hi,
Yes it is from the calender table. I tryed to change the realitonsship, sorted the date column but the result did not change.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
118 | |
107 | |
70 | |
70 | |
43 |
User | Count |
---|---|
148 | |
104 | |
104 | |
89 | |
66 |