Forum Discussion

Porkey's avatar
Porkey
Frequent Visitor
3 years ago
Solved

Need help inserting specific date from same row into the table

  I want to insert the date from row 1 into the Table on row one, the code ive used has inserted the dates as a list so they are all present. Is there a waty to get just the date from that row...
Need Help
  • edhans's avatar
    edhans
    3 years ago

    You need to trap that value (date) in a variable first, then reference the variable inside the Table.AddColumn. Something like this:

     

    Table.AddColumn(
                #"Invoked Custom Function", 
                "Custom", 

                 each 
				 	let
						varDate = [Date]
					in
					Table.AddColumn(
                                       [ContentAdder],  
                                       "Date",
                                        each varDate,
                                        type date
                                       )
                )
AlienSx's avatar
AlienSx
Super User
3 years ago
Table.AddColumn(
    #"Invoked Custom Function", 
    "Custom", 
    (x) => 
        Table.AddColumn(
            x[ContentAdder],  
            "Date",
            (y) => x[Date],
            type date
        )
)