Forum Discussion
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 value is founded... something same to VLOOKUP in Excel
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.
3 Replies
- amitchandak
Super User
mohammedmqi ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Refer if these can helphttps://exceleratorbi.com.au/text-filtering-power-bi/
https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381309?src=office&tab=Overview
Appreciate your Kudos. for exampl i have this table
i want total by sum amount which have text content
SCRRY01
SCRRY02
SHLJA01
SHLJA02i need result as you see here below (this is will be my new table so i need forumal for total part)
v-zhenbw-msftCommunity Support
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.
