Relative Date last month not current month

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!