Solved: Is there a way to extract certain words out? - Page 2

hidenseek9 · ‎09-12-2017

Hello Power BI Community!

I have a question regarding DAX expression.

I have a dummy data below.

In the file, I have a data with names of products and weight out of each product in text.

What I would like to do is to extract just the text on weights (i.e. 75GX4PX6)

Then I would like to calculate the weight of the total product. (i.e. 75*4*6= 1,800)

However, the weight in the text is not listed in a consistant format or

a length of characters is not always the same.

Is there a way to extract just the weight text?

Or a direct way to calculate the total weight?

Many thanks,

H

MarcelBeug · ‎09-19-2017

It depends.

If the pack size is always the third number, then you can adjust the "Product" step to have only the first 2 values multiplied.

    Product =               Table.TransformColumns(NumberFrom,{{"Weight", each List.Product(List.FirstN(_,2))}}),

Otherwise I'm curious how you are going to create the column with the number of packs per case.

Specializing in Power Query Formula Language (M)

Is there a way to extract certain words out?