how to comparing between two different type columns from different tables

[Deemah_EO]

Hi everyone ,

i have a case that needed to comparing between two different type columns from different tables,

so i have 2 tables table 1 is "DIM_DATE" , table 2 is "Fact_Employee_Assignment" ,

DIM_DATE have these columns , integer  Date_Key , date  Date

Fact_Employee_Assignment have these columns , integer Effect_Start_date , integer_Effect_End_date

so now i want to this calclation : If ( Effect_Start_date = Date_Key) then Date

how can i solved it ??? 

Please help me

[v-danhe-msft]

Hi @Deemah_EO,

Could you please tell me if your problem could be solved? If it is, could you please mark a reply to close this topic?

Regards,

Daniel He

[v-danhe-msft · Accepted solution]

Hi @Deemah_EO,

Do you mean comparing a number with a data? If so, I am afraid Power BI could not support this ferture currently, you could submit an idea in ideas forum:https://ideas.powerbi.com/forums/265200-power-bi-ideas

Regards,

Daniel He