SAMEPERIODLASTYEAR is returning end of month instead of specified dates

Anonymous — Mon, 23 Mar 2020 19:23:38 GMT

Hoping to get some help here on an issue I have never seen.

Typically, I use SAMEPERIODLASTYEAR and setup a specific calendar table for all my Power BI reports. No issues with any other report but this one I am currently working on.

This issue creates errors across the entire report, but it can be distilled down to when I run the SAMEPERIODLASTYEAR calcuation (on a date such as 3/23/2020), it returns the end of the month of the previous year (3/31/2019), instead of my desired date (3/23/2019).

The below screenshot is what is occurring. My calendar table currently has not relationships to any other tables.

Re: SAMEPERIODLASTYEAR is returning end of month instead of specified dates

Greg_Deckler — Mon, 23 Mar 2020 20:01:06 GMT

First Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Second See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008

topic Re: SAMEPERIODLASTYEAR is returning end of month instead of specified dates in DAX Commands and Tips

SAMEPERIODLASTYEAR is returning end of month instead of specified dates

Re: SAMEPERIODLASTYEAR is returning end of month instead of specified dates