Forum Discussion

mim's avatar
mim
Icon for Advocate V rankAdvocate V
6 years ago
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...
Need Help
  • Brian_M's avatar
    Brian_M
    6 years ago

    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!

mim's avatar
mim
Icon for Advocate V rankAdvocate V
6 years ago

amitchandak  my case is different, my weekend is not fixed, basically, I want the weekend to change based on another measure