Hi,
Working on a fairly complicated measure where I need to spread data for a product across multiple months, before a certain End Date. The measure works fine on Row and Column level but for the Row Total it breaks. Due to the absence of a Month filter in the Grand Total Context it returns values for the full year instead of summarizing the table.
I have tried the normally suggested solutions; "Final Word" measures etc, but can't get it to work. Would appreciate any help on the subject!
I have attached a sample pbix file that represents my data and relationships and also shows the expected outcome. My assumption is that a 3rd outcome of the final IF Statement is needed, using CALCULATE to define the time period the calculation should be conducted over.
Sample File: DropMeFiles – free one-click file sharing service
Thank you in advance!
Rasmus
