Forum Discussion
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...
amitchandak
Super User
Super UserAnonymous , Not very clear.
First of all Do use .date unless there is a timestamp. If it is datetime. Create a new date column and join with the date table. If you have more than one dates in one table then you need inactive relation and use relation.
or video -https://youtu.be/e6Y-l_JtCq4
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-msftCommunity Support
Hi Anonymous ,
Could you pls upload the relationship schema between tables?
Best Regards,
KellyDid I answer your question? Mark my post as a solution!