Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
How to to apply a dynamic date filters ?
i am trying to get the latest weekend date form a weekend date column from a power BI dashboard view. Trying to achive this with the "M script" and pass the parameters from the user selection with in the dashboard.
My datasource is an MDX query or MSOLAP cube.
Appricipate your help...!
Solved! Go to Solution.
Hi @Anonymous,
You can take a look at below article which told about apply dynamic date filter in query editor:
Power Query M filter data by Dynamic Date (PQ not DAX) Start of Month
Regards,
Xiaoxin Sheng
Hi @Anonymous,
You can take a look at below article which told about apply dynamic date filter in query editor:
Power Query M filter data by Dynamic Date (PQ not DAX) Start of Month
Regards,
Xiaoxin Sheng
It works for my requirment,Thank you so much...
| User | Count |
|---|---|
| 23 | |
| 22 | |
| 20 | |
| 19 | |
| 11 |
| User | Count |
|---|---|
| 66 | |
| 56 | |
| 45 | |
| 43 | |
| 30 |