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.
Thanks very much. That worked a treat.