multiple column relationship

[Anonymous]

My data has multiple tables of multiple months. key columns are KPI name and KPI status.

I have two visuals :

1 - % of values per KPI name 

2- % of values per KPI status 

Now my problem is at a time i can either create KPI name relationship  or KPI status relationship as power bi does nt support multiple column relationship 

i tried concatenation of these 2 columns but that does not give desire results becuase i need specific visuals. 

any solution to handle multiple column relationship ?

[Greg_Deckler]

@Anonymous I agre with @Jimmy801 's approach if you want to merge the tables together, Power Query does support multi-column joins. 

If you want to keep them separate, create a combo key column in both like:

Key = [Column1] & "-" & [Column2]

Then create your relationship using that column. But, since this is posted in Power Query so if @Jimmy801 answered your question, please mark his answer as the solution! Thanks!

[Jimmy801]

Hello @Anonymous 

or you connect them in Power Query Table.NestedJoin (you can specifiy more then one column for the join) or you create a new column where you concatenate all needed columns and join this new column

Hope this helps

BR

Jimmy