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.
Thanks for the response. I appreciate this is difficult without a desktop file to sample.
1) I created a table with this code
2) I created a measure with this code
3) I don't know how to create a measure with this code. What is "Your Measure Here" referring to?
I just keep hitting a wall with this code. My plan is to have a matrix table show the last 7 days of data (7 columns of previous days), 10 weeks of data (10 columns of the previous weeks) or 12 months of data (12 columns of previous months) depending what get's selected