Forum Discussion
Multiple Relationships Between Data Table and Calendar table
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.
3 Replies
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.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
hi Pure_123
Could you please share your sample pbix file for us have a test, that will be a great help.
Regards,
Lin
