Forum Discussion
Last Year measure using DATEADD reporting incorrect total
Hi there, I am trying to create a measure for Last Year metrics, using the DATEADD function. I am using the below, with the measure reporting accurate data by date.
Cost LY = CALCULATE(SUM('Table'[Cost (EUR)]), DATEADD('Table'[dated],-1,YEAR)).
However, when I present the data by day, including yesterday (relative to the most recent data in the model) the total reported is inflated by quite a bit. As shown in the screenshot, the total for Cost LY over the date range is around 210k, not 369,824.
I can't identify where this additonal data is coming from, if someone has seen this before, or knows how the troubleshoot this, it would be a great help.
1 Reply
Hi charliecasm , I made up some data, looks your measure is correct, could you please upload your PBI file in order to analyse further? otherwise, could not find out the root cause without your other data.
