Solved: Relationship - Multiple colum

AjithTravvise · ‎04-26-2020

I wanted create a relationship between the tables Confirmed and RDeaths. I wanted both counrty/region and date columns to be linked.

amitchandak · ‎04-26-2020

Create a new column in both table and try

Country Date = [Country/Region] & " - "& [Date]

In direct query mode refer

https://docs.microsoft.com/en-us/dax/combinevalues-function-dax

!! Power BI 101 Interview questions !! !! Master Microsoft Fabric- 36 Videos !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

View solution in original post

amitchandak · ‎04-26-2020

Create a new column in both table and try

Country Date = [Country/Region] & " - "& [Date]

In direct query mode refer

https://docs.microsoft.com/en-us/dax/combinevalues-function-dax

!! Power BI 101 Interview questions !! !! Master Microsoft Fabric- 36 Videos !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

Relationship - Multiple colum

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024

How to Get Your Question Answered Quickly