Forum Discussion

Jeffery24's avatar
Jeffery24
Icon for Helper I rankHelper I
7 years ago
Solved

Using variables in custom column with power query

Hi,   Am new to power query and struggling to find an answer to my issue of a variable lookup column. In my dataset I have lot's of freight shipment data containing date fields, there are subseque...
Need Help
  • ImkeF's avatar
    ImkeF
    7 years ago

    Not exactly sure about your requirement, but could it be this?:

     

    Table.AddColumn(#"Changed Type1", " Setup - Arrival EventA ", each Record.Field(_, #"Arrival EventA")
ImkeF's avatar
ImkeF
Icon for Community Champion rankCommunity Champion
7 years ago

Not exactly sure about your requirement, but could it be this?:

 

Table.AddColumn(#"Changed Type1", " Setup - Arrival EventA ", each Record.Field(_, #"Arrival EventA")
Jeffery24's avatar
Jeffery24
Icon for Helper I rankHelper I
7 years ago

Hi Imke,

 

You saved my week! It was just missing a bracket off end :smileyhappy:

Table.AddColumn(#"Changed Type1", " Setup - Arrival EventA ", each Record.Field(_, #"Arrival EventA"))

Thanks so much, really appreciate it.