Need help to create YTD column & TOTAL column

[mirf]

I need help to create YTD column & TOTAL column in the right side of this table0

There are two slicers: Report_Year & Report_Month. For Report_Month (value from 1 to 12), it has months (from Jan to Dec) in it. For example, in Report Month 2, there are monthly values from January - December (to be make sense, there are actual cost data in January - February & forecasted data for March until December).

How to add YTD column & Total column on the right side of table? For example, if 2 is selected in report month, YTD = sum of Jan & Feb, Total = sum from Jan to Dec. If 4 is selected, YTD = Sum of Jan+Feb+Mar+Apr, Total = sum from Jan to Dec.

Here are my pbix sample file: vehicle data.pbix 

Really appreciate your help

[lbendlin]

You will need to unpivot your month data to make it usable. Does Report_Year/Report_Month  mean you have multiple snapshots? How are these related to the months of data?