Last Year measure using DATEADD reporting incorrect total

charliecasm — Fri, 27 Oct 2023 08:53:42 GMT

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.

Re: Last Year measure using DATEADD reporting incorrect total

Walter_W2022 — Fri, 27 Oct 2023 12:00:44 GMT

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.

topic Re: Last Year measure using DATEADD reporting incorrect total in DAX Commands and Tips

Last Year measure using DATEADD reporting incorrect total

Re: Last Year measure using DATEADD reporting incorrect total