The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
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.