Relative Date last month not current month

[Jan845]

Hello everyone

Is it possible in Powerbi in the Relative date filter, in the Last Months option, to select not the current month but from the last day of the previous month?

Currently I select for example last 12 months, it shows the current month (March), but the month is not over yet, I wanted it to start from the last day of last month.

Is this possible in PBI?

Can anyone help solve this in my file?

Translated with DeepL.com (free version)

My PBIX file: https://stealth.cyborg.co/r#0sft8VMnmcdEEcfopkLER2XiQIt5ZbICKVUoLV68UlU

Thanks for help guys.

[v-huijiey-msft · Accepted solution]

Hi @Jan845 ,

The Relative Date filter automatically adjusts to the current date and does not natively support starting from the last day of the previous month directly in the filter options.

Alternative is:

Create a calculated column that represents dates within the past 12 months starting on the last day of the previous month.

Column1 =
IF(
     Table1[Data] > EDATE(EOMONTH(TODAY(), -1), -11)
     &&
     Table1[Data] <= EOMONTH(TODAY(), -1),
1, 0)

Instead of using the built-in "Relative Date" filter, use the created calculated column as a filter in the report. Filter to include only rows equal to 1.

For more information about the EOMONTH function, please see:

EOMONTH function (DAX) - DAX | Microsoft Learn

If you have any further questions please feel free to contact me.

pbix file is attached.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!