cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not 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]

Performance YTD.PNG

 

 

Please find a link to a demo table.

Demo Table

 

Thank you,

Tamir

1 REPLY 1
v-jiascu-msft
Microsoft
Microsoft

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.