Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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.

Demo Table

 

Thank you,

Tamir

1 Reply

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft 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