Forum Discussion

Pure_123's avatar
Pure_123
Frequent Visitor
5 years ago

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...
Show and Tell
Pure_123's avatar
Pure_123
Frequent Visitor
5 years ago

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's avatar
v-lili6-msft
Community Support
5 years ago

hi Pure_123 

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

 

Regards,

Lin