Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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 into the table?
Table.AddColumn(
#"Invoked Custom Function",
"Custom",
each Table.AddColumn(
[ContentAdder],
"Date",
each #"Invoked Custom Function"[Date],
type date
)
)
edit: the date comes from the file name
Solved! Go to Solution.
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
)
)
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingTable.AddColumn(
#"Invoked Custom Function",
"Custom",
(x) =>
Table.AddColumn(
x[ContentAdder],
"Date",
(y) => x[Date],
type date
)
)
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
)
)
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingThank you very much.
Can i ask why it needs to be trapped in a variable? or if you cold point me to some reading that would explain.
In trapping the variable the way I did, I got the value outside of the context of the next Table.AddColumn() function. You can read more about it here. M Language basic concepts - PowerQuery M | Microsoft Learn
But it is similar to using a variable in DAX to trap values at an outer context vs using EARLIER() in the inner context.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingThe Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 19 | |
| 10 | |
| 9 | |
| 8 | |
| 7 |