Forum Discussion

mim's avatar
mim
Advocate 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!

v-xicai's avatar
v-xicai
Community Support
6 years ago

Hi mim ,

 

You couldn't have a calculated column interacted with a slicer or interaction , since columns are only calculated when data is loaded/refreshed.  So you may need to click "Refresh" button for every time you make filter in slicer or interact with other visual.

 

In addition, you may create the [dynamic Week End] using measure instead of calculated column like DAX below, While it may not be displayed in Data view, you may show it in table visual using fields as you need.

 

dynamic Week End= MAX([Date]) -MOD(MAX([Date]) - WEEKDAY([Cutt off daily], 2) -2, 7)+6

 

Best Regards,

Amy 

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.