topic Need Help in DAX Commands and Tips

Need Help

Semaj06Fr — Sun, 15 Sep 2024 14:32:39 GMT

Hello everyone,

I’m seeking assistance because I can’t seem to find a solution to my issue. I truly appreciate any time and help you can provide to address my request.

Thank you in advance for your support!

Here are my data. For each material, I have its description and the name of its component.

Material	Description	Raw Mat
A	Product A	B
B	Product B	AA
C	Product C	D+E
E	Product E	BB

What I would like to achieve is the following result: When I select a finished product, it gives me the details of the operations to perform and the components to use. I would like a table like the one below:

Material	Description	Raw Mat	RM Des	RM Raw Mat
A	Product A	B	Product B	AA
C	Product C	D		Raw Mat
C	Product C	E	Product B	BB

Re: Need Help

JamesFR06 — Sun, 15 Sep 2024 14:51:11 GMT

Hello. Just to follow

Re: Need Help

Anonymous — Tue, 17 Sep 2024 06:42:55 GMT

Hi Semaj06Fr

Please try this:

Here's the sample table:

Click Transform data in the Home pane to use the power query:

Then add a custom column in the Add Column pane:

Text.Split([Raw Mat],"+")

Click Expand to new Rows:

Click Merge Queries in the Home pane:

Select the Custom column from the original table and Material column from the current table.

The result is as follow:

Best Regards

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