Creating Custom Columns with Dynamic Column Names in Power Query

Поделиться
HTML-код
  • Опубликовано: 3 фев 2025

Комментарии • 8

  • @pon00050
    @pon00050 3 месяца назад +1

    = Table.AddColumn(Source, "Custom Column", each Record.Field(_, [Column Name]))
    General Use: Dynamically extracts a specific field from a record in each row of a table, based on a given column name.

  • @mohamadfawaz1928
    @mohamadfawaz1928 Год назад +1

    Awesome 🎉

  • @sumardjo
    @sumardjo Год назад +1

    Wow
    thanks to my practices
    to learn with sample file
    thanks youuuu

  • @alessandroverde1885
    @alessandroverde1885 Год назад

    great !! thanks from Italy

  • @luigibru8677
    @luigibru8677 6 месяцев назад

    Based on the "Column Name" it returns one among the other 3 columns (G, H, I)... for example the first line is "Supplier" so in the "Custom Column" returns "Tokyo Traders".

  • @alterchannel2501
    @alterchannel2501 Год назад +1

    Not sure of what's going on

  • @mirrrvelll5164
    @mirrrvelll5164 Год назад +1

    Can you say what is going on here?

  • @shivaam-lu8in
    @shivaam-lu8in 8 месяцев назад

    Whats happen?