cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Deemah_EO
Advocate I
Advocate I

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

1 ACCEPTED SOLUTION
v-danhe-msft
Microsoft
Microsoft

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

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-danhe-msft
Microsoft
Microsoft

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

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-danhe-msft
Microsoft
Microsoft

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

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors