Forum Discussion
how to comparing between two different type columns from different tables
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
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
2 Replies
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
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