Forum Discussion
Solved
Combine Two Tables with Same Column Names for One Chart
I have two computed measures from different tables that have the same Value Names so I am trying to combine them into one table for the desired outcome. This is what I get:
| Division | Open Last 7 Days | Division | Closed Last 7 Days |
| Accounting | 5 | ||
| Legal | 4 | ||
| Accounting | 3 | ||
| Legal | 2 |
Desired Outcome that I would like is:
| Division | Last 30 Days |
| Accounting | 8 |
| Legal | 6 |
I think you should create a common division and join with both tables.
And create a combined measure
last 30 day =[Open Last 7 Days] + [Closed Last 7 Days]
2 Replies
Very difficult to tell what is going on here. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
I think you should create a common division and join with both tables.
And create a combined measure
last 30 day =[Open Last 7 Days] + [Closed Last 7 Days]
