How to compare 2 data (id columns) that have multiple values

[FluffyPotato]

This post is closed.

[FluffyPotato]

!

[v-zhangti · Accepted solution]

Hi, @FluffyPotato 

See if this meets your desired results?

Column:

Need Skill = 
CALCULATE(MAX('Job Skill'[Skill Name]),FILTER('Job Skill',[Job Name]=EARLIER(Position[Job Name])))

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-zhangti]

Hi, @FluffyPotato 

Can you give us an example of a job and tell us what you expect the output to be? Sensitive information can be removed in advance. You can also show it with pictures.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.