Forum Discussion
Solved
group by dynamic week
I have this calendar that calculated week based on a particular weekend, which is the last date from another table using this measure "Cutt off daily", everything was fine, untill someone wanted a sl...
Note that the Calendar table has to be marked as a date table for the time intelligence (DATESBETWEEN) functions to work.
Based on your response on twitter, the pbix file also has a YTD version for the sum of qty.
Hope that helps!
Is there an example file we can have a crack at, would love to give it a go!