Forum Discussion
Combine Two Visual Tables
I've been given a report that contains two tables in Power Bi. They're identical fields except for one column from a different table. My task is to combine both visuals into a single visual. The e...
Hi Anonymous !
Correct me if I'm wrong, the second column is either 'Data 2' or 'Data 5' while the other columns are the same?
How do you determine whether it's 'Data 2' or 'Data 5'?
Perhaps following solutions could give you the desired result:
1. You could use the switch function to return either 'Data 2' or 'Data 5' depending on a condition.
Measure =
VAR Result = SWITCH(TRUE(),
Type=1 ,[Data 2],
Type=2 ,[Data 5]
)
RETURN
Result
2. Or if 'Data 2' and 'Data 5' don't overlap you could just add them to eachother in Power Query or Dax.
Hope it helped!
Kind regards,
OD
Data 2 and Data 5 are different columns in two different tables. The report makes two visual tables to capture all of the data, and I'm trying to combine it all into one table.