https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DATEADD-is-not-returning-Total-sales-from-previous-year/m-p/4314987#M171337 <P>The measure is working, but you don't have any filters on the card visual. That means that the entire date table is visible in the evaluation context, so the DATEADD is showing all dates prior to 2024. If you put the PY measure in the column chart it works.</P> <P>You could add a relative date filter to the card visual to only show the current year.</P> Thu, 05 Dec 2024 09:13:13 GMT johnt75 2024-12-05T09:13:13Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DATEADD-is-not-returning-Total-sales-from-previous-year/m-p/4314967#M171335 <P>I have an issue with dateadd function that not returns total sales from previous year:</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>What is wrong?</P><P>&nbsp;</P><P><A href="https://drive.google.com/file/d/1Y2eJD4NTWY8eCLfb7SB2FlnFwAgCH4qW/view?usp=sharing" target="_self">https://drive.google.com/file/d/1Y2eJD4NTWY8eCLfb7SB2FlnFwAgCH4qW/view?usp=sharing</A>&nbsp;</P> Thu, 05 Dec 2024 09:04:34 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DATEADD-is-not-returning-Total-sales-from-previous-year/m-p/4314967#M171335 gumis_rulez 2024-12-05T09:04:34Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DATEADD-is-not-returning-Total-sales-from-previous-year/m-p/4314987#M171337 <P>The measure is working, but you don't have any filters on the card visual. That means that the entire date table is visible in the evaluation context, so the DATEADD is showing all dates prior to 2024. If you put the PY measure in the column chart it works.</P> <P>You could add a relative date filter to the card visual to only show the current year.</P> Thu, 05 Dec 2024 09:13:13 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DATEADD-is-not-returning-Total-sales-from-previous-year/m-p/4314987#M171337 johnt75 2024-12-05T09:13:13Z