Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

How do I do a VLOOKUP in PBI

The below is my example. I have a list of items that are either stock or not, and some of them have an alternative number. For those that do have an alternative, I want to check if the alternative is...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,

     

    If you were creating a measure. You can create as

    Is_Alternative_Item_Stock_ = LOOKUPVALUE('Item'[Item Is stock],'Item'[Item Number],SUM('Item'[Item Alternative Number]))

    Here's the result:

     

    You can download my attachment for more details.

     

     

    Best Regards,

    Stephen Tao

     

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