Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

Need help to create YTD column & TOTAL column

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

Super User
Super User

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?




Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors