How to filter Max(Date) - 31 days ?

Hi suvechha 

You should be able to adjust the Date field to the following criteria:

The output will look like the below (note that my Date table in this example has 30 September as the max date):

Hope this helps 🙂

Theo

suvechha 

I believe relative slicer will do your favor. 

Use a relative date slicer or filter in Power BI - Power BI | Microsoft Docs

Best regards
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

Hi @suvechha 

If my earlier post doesn't achieve what you are after, you can also use the Relative Filter to achieve the identical outcome. Alternatively, you can use 1 month etc rather than 31 days (similar to that of the earlier post).

Hope this helps  🙂

Theo