I'm trying to add a custom column and fill in dates between two dates.
I'm trying to add a column to this set of data:
= Table.AddColumn(#"Added Custom1", "FillInDate", each List.Dates([Starting_Date],Duration.Days([Duration])+1,#duration(1,0,0,0)))
...but I get this error message.
Expression.Error: The name 'Added Custom1' wasn't recognized. Make sure it's spelled correctly
Thanks in advance
Go to Solution.
You are referencing a step that appears after the current #"Filtered Rows5" step. Power BI doesn't know about #"Added Custom 1" yet.
Try something similar to the following instead to reference the output of the prior step:
= Table.AddColumn(#"Filtered Rows5", "FillInDate", each List.Dates([Starting_Date],Duration.Days([Duration])+1,#duration(1,0,0,0)))
Power BI Super User, Greg Deckler, explains
Register by September 5 to save $200
Engage and empower students with Power BI!
Continue your learning in our online communities.