Forum Discussion

mohammedmqi's avatar
mohammedmqi
Regular Visitor
5 years ago
Solved

search formula something Like Excel VLOOKUP

i'm trying to create a table that can search in other table column fields content a text that might be a full field or part of the field,,, and after that give us the total of anther column where val...
Need Help
  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    5 years ago

    Hi mohammedmqi ,

     

    We can use the SPLIT function and create a table visual to meet your requirement.

     

    1. Duplicate the account diamantion column and split it by “-”.

     

     

    2. Then we can create an one-to-many relationship based on account diamantion.

     

     

     

    3. Or you can create a calculate column in Table 2.

     

    Column = CALCULATE(SUM('Example table'[amount]))

     

     

    If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?

     

    Best regards,

     

    Community Support Team _ zhenbw

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

     

    BTW, pbix as attached.