Forum Discussion
Power BI - Custom Date Range Filter Support
Hi ShaneHi
You are right, I made a mistake here. Thank you for pointing it out. DATESINPERIOD only supports days, months, quarters, and years. Here is the changed DAX:
"Last 10 Weeks", DATESINPERIOD('Calendar'[W/C Monday], MAX('Calendar'[W/C Monday]), -10*7,Day)
Since I don't know your specific data structure and don't have any sample data, I can only provide you with a potentially effective method.
If you can provide sample data that does not contain any private information, it will greatly help in solving your problem.
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
I'm still stuck with this and wondering if you can help some more.
As I asked in my last response, in step 2 - was I right to create a DAX Measure with this code?
And in Step 3 - I'm assuming "YOUR MEASURE" refers to what i'm trying to output? The problem is - i'm hoping to have the slicer as a Date Column in a Matrix which contains multiple measures