Forum Discussion

AngieM's avatar
AngieM
New Member
2 years ago
Solved

DAX Formula Help

I have two tables in my Power BI, both include a student ID code, a course code, and course credit hours. I want to find the matches between the two tables, where the 1st table (enrollment) looks for...
Need Help
  • NaveenGandhi's avatar
    NaveenGandhi
    2 years ago

    AngieM 

    Just concat the course and hourse and use below dax to do a lookup.

    Match/NoMatch = if(ISBLANK(LOOKUPVALUE(Schedules[Key],Schedules[Key],Enrollement[Key])),"No Match","Match")


    If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!

    Follow me on LinkedIn!!!

NaveenGandhi's avatar
NaveenGandhi
Memorable Member
2 years ago

Hi AngieM 

Please post sample data, expected output along with screenshots to understand the problem better.

Regards,

NG

  • AngieM's avatar
    AngieM
    New Member
    2 years ago

    added, thank you

    • NaveenGandhi's avatar
      NaveenGandhi
      Memorable Member
      2 years ago

      AngieM 

      Just concat the course and hourse and use below dax to do a lookup.

      Match/NoMatch = if(ISBLANK(LOOKUPVALUE(Schedules[Key],Schedules[Key],Enrollement[Key])),"No Match","Match")


      If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!

      Follow me on LinkedIn!!!