Forum Discussion
Match Multiple Values in a cell with another cell
Hi,
I have a dataset as below:
| Name | Size | Type | Tier |
| A | 100 200 300 400 | Unmanaged Unmanaged Managed Managed | Standard Standard Standard Premium |
| B | 100 200 300 400 | Unmanaged Managed Unmanaged Unmanaged | Premium Premium Premium Premium |
In Name A, I have four values on other cells. I want to match like below:
Name: A
Size: 300
Tier: Standard
Type: Unmanaged
Name: A
Size: 300
Tier: Standard
Type: Managed
Name: A
Size: 400
Tier: Premium
Type: Managed
Likewise:
Name: B
Size: 800
Tier: Premium
Type: Unmanaged
Name: B
Size: 200
Tier: Premium
Type: Managed
I tried the below method but failed:
Split the Columns by rows. When i did that the Size rows are also increasing, hence the count doesn't happen correctly.
Any other methods please??
10 Replies
Hello Anonymous
here you have my example file
First I filled in all your lines with the names (A,B) in the PowerQuery Editor with the fill down option.And this table was loaded into PowerBI from then on it was easy to achieve your desired result.
If this post was helpful may I ask you to mark it as solution and give it a 'thumbs up'? This will also help others
Have a nice day!
BR,
Josef
Graz - AustriaHi. Thanks for your response and sorry for the late response.
Data set is not like you mentioned. It is like below:
When I spli Size, Type and Tier by Rows, the data becomes as below:
And the list goes on...................... I am not able to get the correct sum of the Size according toType and Tier.
Please help me with this!! Thanks in advance.
