Getting total open backlog and show over time

[JezMazter]

Hello, 

I am quite new to powerbi , but been liking it so far. 

I have a question regarding showing totals of an open backlog from week to week.

To give context, I am extracting an open backlog weekly. I want to show the total from week to week. The end goal would be something to look like this:

The data source is from an excel with multiple tabs which contain the extracted backlog from each week.

How am I able to show the total of each backlog across the weeks?

Thank you in advance

[amitchandak · Accepted solution]

@JezMazter , Append these table with Week No or week date column

or have week no or date column and join all of them with a common week/date table and the sum of measures from all three tables

Sum('Week 38 backlog'[Value]) + Sum('Week 39 backlog'[Value]) +Sum('Week 40 backlog'[Value])

https://amitchandak.medium.com/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solutio...