Forum Discussion

Samarth-Borade's avatar
Samarth-Borade
Frequent Visitor
3 years ago

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 ne...
"Date Table"
"DAX"
CALENDER
some_bih's avatar
some_bih
Icon for Community Champion rankCommunity Champion
3 years ago

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