Forum Discussion
Getting total open backlog and show over time
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
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])
1 Reply
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])