Forum Discussion

mraka9's avatar
mraka9
Helper III
4 years ago
Solved

Linking related items within the same table-Power Query

I need help with Power Query. I have a table with columns: A, B and C Column A and C contain identical items to be linked. I want column C to check where everything is in column A and show concate...
Need Help
TomMartens's avatar
TomMartens
Super User
4 years ago

Hey mraka9 ,

 

if you change this line

Table.SelectRows( #"Changed Type" , each [C] = filtervalue )[B]

to this

Table.SelectRows( #"Changed Type" , each [A] = filtervalue )[B]

the function returns what you are looking for:


Regards,
Tom

  • mraka9's avatar
    mraka9
    Helper III
    4 years ago

    Hello Tom,

    can you upload the pbix file.
    The language in Power BI is not English for me, so I can't just copy.
    Thank you very much. That might be the solution I'm looking for!

  • mraka9's avatar
    mraka9
    Helper III
    3 years ago

    Hello Tom,

    can you customize the function?
    Column B is in text form for me. It is not necessary to change the garden in operation.

    Although everything in the example is mostly shown as a number, there is also text.

    Apologies and thank you very much in advance!

    • TomMartens's avatar
      TomMartens
      Super User
      3 years ago

      Hey mraka9 ,

      change this line

      , each Number.ToText( _ )

      to this

      , each  _


      Regards,

      Tom

      • mraka9's avatar
        mraka9
        Helper III
        3 years ago

        Thanks Tom!
        I will try to do it that way, I hope it will work then.
        nice greetings,