Multiple Relationships Between Data Table and Calendar table

[Pure_123]

Hi

I have two date columns in my data table (eg completion Date and offer Date) and want to join both of these columns to the Date table. If there were only 1 date column, then it would typically set up completion Date column as an active relationship and the offer Date as inactive relationship and use USERELATIONSHIP function to join the offer date.
But my following measure doesnt allow me to create the measure and get the warning as below.

how can i resolve this warning and make this work please.

 

[amitchandak]

@Pure_123 , Is there an inactive/Active join between Offer Month and Date of Date. Also Is Month is month or date.

Please check the issue seem like missing join.

Refer example :https://www.youtube.com/watch?v=e6Y-l_JtCq4

Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.

[Pure_123]

Hi @amitchandak   

Completion Month has the active join and offer month has the inactive join.

Offer month was in date time format (Pic 2), but i formatted to the  following highlighted format to match calender date column.

Thanks 

[v-lili6-msft]

hi @Pure_123 

Could you please share your sample pbix file for us have a test, that will be a great help.

Regards,

Lin