Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Samarth-Borade
Frequent Visitor

Cant create relationship between Date and Calender[Date] .

now i have multiple tables CFS_Import , CFS_Export and CL now i have one more table name List , so i have created relationship between These three tables and the List table , now i when i create a new table named Calendar which contains only Date column , i want to link all the three table Date column with this column , so that when i drag this Calendar[Date] in any slicer it can act as a unified date slicer or when i drag it to x-axis of any line chart and add revenues of different table it will work 'fine , but i am only able to make relationship between one of the table and the rest two table's relationship turns inactive and when i try to turn it active it gives error for ambiguity.

1 REPLY 1
some_bih
Super User
Super User

Hi @Samarth-Borade only one active relationship in Power BI guarantee filter propagination between tables. To leverage inactive relationship between one calendar / date table, beside active one, you should use DAX  function USEREATIONSHIP. On link below you can find example how to use it in measure. Hope this help.

 https://learn.microsoft.com/en-us/dax/userelationship-function-dax 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.