Forum Discussion
moldfield
4 years agoFrequent Visitor
Decreasing Running Total Measure with Date Hierarchy
Hello, I have a running total measure of costs with an end date and the quick measure function with some small changes gives a correct output. I'd like to represent this in Quarters,...
- 4 years ago
Nevermind, used the wrong columns.
This is what I wanted.
moldfield
4 years agoFrequent Visitor
Another thing I've tried was creating a table with all the years and quarters then doing a Full Outer Merge to give me the null Quarters then remake the measure, which is closer but now it's omitting the empty Quarters even if I select the "Show items with no Data" option in the visual".
Out of ideas.
moldfield
4 years agoFrequent Visitor
Nevermind, used the wrong columns.
This is what I wanted.