Forum Discussion
Solved
Add Column Comparing Two Date Columns and Returning the Next date in Column 2 from Column 1
I am customizing my date table for my business. I have built a column containing only the dates we are open. As we are closed on the weekend I have null values for Saturday, Sunday and holiday closur...
You may be able to add the column referencing the [date_open] column and then doing a Table.FillUp() (or Table.FillDown() depending on which way the table is sorted) step to the new column.
Thank you for looking.
Table.AddColumn(#"Removed other columns", "result", each Table.FillDown(table name, [date_open]))
Result was an error:
Expression.Error: A cyclic reference was encountered during evaluation.
That's the error I've seen a lot so I must be doing something fundamentally off. The table I'm using is the name of the table.
Try doing it in two steps.
Add a column that is just [date_open] and then in the next step fill down that column.