riley_walburger's avatar
riley_walburger
Regular Visitor
3 years ago
Status:
New

Multiple Column Relationships within Model View

I would love to be able to make relationships between tables by two columns.


For a simple example being able to make a relationship between Year and Month between two tables. This would allow it to be a one to many or one to one relationship rather than creating whole new table through a merge to be able to do this.


*I know this is an easy work around with a date column but other key columns are not easily fixed in that sort of way.


It would be similar to joining two tables in SQL ON two columns.


table1.Year = table2.Year AND table1.Month = table2.Month

This would instead define the relationship between two tables in PowerBI.


Maybe be able to hit ctrl, select two columns and drag them to another table to build that relationship in a similar manner as a relationship is made right now.

Recent ideas