Forum Discussion
Anonymous
7 years agoNot applicable
YTD Running Totals based on current visual table
Hello,
I have a table with Months as its first column and a score value as the second column.
The score is a complex measure that is calculated from various measures and tables. It is not a figure in a specific table.
I don't seem to get it right for creating a YTD running total of that measure.
I tried:
Overall Performance YTD =
CALCULATE (
SUMX ( VALUES ( dimCalendar[MonthYear] ), [Overall Performance] ),
FILTER (
ALLSELECTED ( dimCalendar[MonthYear] ),
dimCalendar[MonthYear] <= MAX ( dimCalendar[MonthYear] )
)
)The result should be :[20,44,68...etc]
Please find a link to a demo table.
Thank you,
Tamir
1 Reply
- v-jiascu-msft
Microsoft Employee
Hi Anonymous,
I didn't see anything you described here in the demo. Can you check the demo file, please? Seems the result is right in the demo.
Best Regards,
Dale