Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

connecting multiple dates in 1 table to a date table

Hi All,   I have a table which has a createdate and deliverydate. I want to connect both of these to a date table. I am able to connect mt createdate but when i try to create a relationship between...
Need Help
negi007's avatar
negi007
Icon for Community Champion rankCommunity Champion
5 years ago

Anonymous Since you can have only active relationship between two tables, your second relationship will be inactive. However, you can still use inactive relationship in your measures. 

 

Orders Shipped = CALCULATE( sum(Sales) ,USERELATIONSHIP('Date'[CreateDate], Sales[DeliveryDate]) )

 

refer to below link for more details.

 

https://docs.microsoft.com/en-us/power-bi/guidance/relationships-active-inactive