Forum Discussion

torsten_FO's avatar
torsten_FO
Helper I
3 years ago
Solved

Select a value from Table with Power Query M

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...  
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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