How to build a relationship for these 2 date columns from different tables?

[Anonymous]

Hi, I'm trying to build a relationship for these 2 date columns from different tables. But seems that I'm keep getting this message. 

Any solution for this? 

[Anonymous]

@Anonymous 

Please, before you start modeling in PBI, get familiar with the philosophy behind this tool. Otherwise you'll be constantly shooting yourself in the foot. You can start here: Model relationships in Power BI Desktop - Power BI | Microsoft Docs

[amitchandak]

@Anonymous , You need to create a common date table and join both tables with that and you can use columns from date table for filters

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.