Forum Discussion
SignorSoprano
Helper I
3 years agoDAX Cumulative Total over weekending dates
For the life of me, I cannot get this measure to work at the granularity of weeks. It works for Months, Quarters, and Years, but not weeks. CumulativePlannedHours =
CALCULATE(
SUM(pbiTask...
- 3 years ago
SignorSoprano Try Better Running Total: Better Running Total - Microsoft Power BI Community
Greg_Deckler
Community Champion
3 years agoSignorSoprano Try Better Running Total: Better Running Total - Microsoft Power BI Community
SignorSoprano
Helper I
3 years agoGreg_Deckler I thought for sure I tried this formula before and it didn't work. I think the difference was that I didn't put the filtered table in a variable, but rather filtered it directly in SUMX.
Thanks.