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 se...
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
