Forum Discussion

powerbi_lost's avatar
powerbi_lost
Frequent Visitor
4 years ago
Solved

Lookup using DAX

This is the result I am looking for. It's a table visual created in the report view. I want to get the April vaules from the lookup table below and match it for each branch:   Lookuptable: ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi powerbi_lost ,

     

    According to your screenshot, I know [Branch] and data in each month are in same table. I think you don't need to use dax to lookupvalue in April. You can add [Branch] and [April] columns in table visual and then you can get the result you want. Power BI will lookupvalue automaticlly by context. If you want to calculate [April] by measure, you can try sum function to get summarize value.

    April Measure = SUM('Table'[April])

     

    Best Regards,
    Rico Zhou

     

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

PhilipTreacy's avatar
PhilipTreacy
Super User
4 years ago

Hi powerbi_lost 

 

Your request isn't very clear.  What's the lookup table?  What are you looking up?  How is your data connected?  What does your data look like?  What does your desired result look like?

 

Please provide sample data (not pictues) and show what you want the final table to look like.

 

Regards

 

Phil

  • powerbi_lost's avatar
    powerbi_lost
    Frequent Visitor
    4 years ago

    Hi Phil,

    I edited my post and I hope it's more clear now. If you want the data I can personally email you the file I'm wokring on. 

     

    Thanks. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi powerbi_lost ,

       

      According to your screenshot, I know [Branch] and data in each month are in same table. I think you don't need to use dax to lookupvalue in April. You can add [Branch] and [April] columns in table visual and then you can get the result you want. Power BI will lookupvalue automaticlly by context. If you want to calculate [April] by measure, you can try sum function to get summarize value.

      April Measure = SUM('Table'[April])

       

      Best Regards,
      Rico Zhou

       

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