Forum Discussion
Measure using time not totalizing - Complex one.. I guess.
- 4 years ago
Hi, chlxco
According to your description, Is the 'total' displayed incorrectly?
If yes, you can try:
Total Hours = SUMX ( SUMMARIZE ( Table, [Start Date], [End Date], [Time x Month], "a", CALCULATE ( SUM ( Table[Time x Month] ), FILTER ( VALUES ( Table[Start Date] ), Table[Start Date] <= MAX ( Dates[Date] ) ), FILTER ( VALUES ( Table[End Date] ), Table[End Date] >= MIN ( Dates[Date] ) ) ) ), [a] )Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.
Best Regards,Community Support Team _ Janey
Hi YukiK,
I tried without success. When I translated into my model it takes me to the same place where I started here. It just gives me the last month time, not te cumulative amount across months (like the Total Hours does it). The other challenge I found is that SUM does not accept Calculated Measures (Total Hours). Bottom line, I need to sum Total Hours based off of the Date range I filter. Thx
Is this what you're looking for?
If looking to do cumulative amount by month, then you'd just change Start Date with Month