Forum Discussion

FluffyPotato's avatar
FluffyPotato
Frequent Visitor
3 years ago
Solved

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

This post is closed.

Need Help
Tutorial Requests
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    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.

     

3 Replies

  • v-zhangti's avatar
    v-zhangti
    Community Support
    3 years ago

    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.

    • v-zhangti's avatar
      v-zhangti
      Community Support
      3 years ago

      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.