Select a value from Table with Power Query M

[torsten_FO]

Hi,

I have this Table (Snap_To_DB):

How can I select the Value from Column "Value" at the line "Value_1"?

I need this in Power Query M code.

Thanks...

[v-cgao-msft · Accepted solution]

Hi @torsten_FO ,

You need to further explain what your expected output is (a table, a list or others).

Please try this:

= Table.SelectRows(#"The name of the previous step", each [Data] = "Value_1")[Value]

The original table:

result:

Attach the test code for reference:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCkvMKU2NN1TSUTI0MFCK1YGJGAFFjFBEjIEixigiIF0mGLpMQSKxAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Data = _t, Value = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Data", type text}, {"Value", Int64.Type}}),
    #"test" = Table.SelectRows(#"Changed Type", each [Data] = "Value_1")[Value]
in
    #"test"

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[AnkitKukreja]

Hi! @torsten_FO 

Can you please share some sample data and desired output? Your problem is not very clear to me.