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.

mohammedmqi's avatar
mohammedmqi
Regular Visitor
5 years ago

for exampl i have this table

 

i want total by sum amount which have text content
SCRRY01
SCRRY02
SHLJA01
SHLJA02

i need result as you see here below (this is will be my new table so i need forumal for total part)