Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
randomUser21
Resolver I
Resolver I

how to make custom filter (with dax ? ) on page report

Hello everybody,

i want to create a custom report filter, i want the report page to be filtered to current date and same date last month, same date last 2 months....

for example today is 07/09/2023 (dd/MM/YYYY format) I want the page to be automatically filtered on the date of (07/09/2023, 07/08/2023, 07/ 07/2023, 07/06/2023)


can someone help me please

THANKS

Best regards

1 REPLY 1
lbendlin
Super User
Super User

This will only work if you 

 

- have a Calendar table

- refresh that calendar table in import mode every day

- only have users in a single timezone.

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors