Create a custom measure that totals "total demand" for 7 days
Want to create a custom measure that sums the "total demand" for a total of 7 days from the next day to the next 7 days.
I created a custom measure with the expression "Fsum(Total Demand,7)" to achieve the above objective, but it does not work as expected.
➡Measure on 7/11: contains values for 7 days from 7/12~7/18
➡The calculation has been completed for each weekly bucket.
Measure on 7/17:value from tomorrow through the weekend is in.
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):