Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Use active and inactive relationship for DimDate

Hi Everyone, Is there any way to use both active and inactive relationships in one calculated column? I have the following calculated column;   CALCULATE(COUNT(SHIPPING_LINE[KeyID]); FILTER(CD_O...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Yes they all have time stamp hence I use .[Date]. I have more than one date column  in my table and I created one active and 2 inactive relationships between SHIPPING_LINE tabel and Date table. However, I do not know how to use "USERELATIONSHIP" within one calculate function as described above. 

v-kelly-msft's avatar
v-kelly-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi  Anonymous ,

 

Could you pls upload the relationship schema between tables?

 
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!