Forum Discussion
Cumulative quantity per day and other fields
Super UserYou need to include Calendar dimension in your model and flag which are holidays week and then from there you calculate number of days and execute your business logic.
There are many post on how to create calendar/date dimension in PowerBI and that is the key for your solution.
I had hoped that since the logic was as simple as Week Number < 47, I might be able to do it as a formula rather than adding the complexity of an extra table.
- parry2k
I guess your week number is not always 47 as static value. As part of best practice, highly recommended to add date dimension on any time intelligence based reports.
I've added a calendar table and can't figure out how to use it to get what I described in my original post.
With the calendar table, I can more easily use Lookup to add a Holiday/Non-Holiday field that helps me sum the quanties for the proper dates. But I still can't figure out how to somehow add up the days elapsed from start to finish while excluding days categoried as "Holiday".
Any ideas?