Forum Discussion
pbrainard
Helper III
Helper IIIError generating list of dates
I need to create a list of dates between an Enrollment Date and a Dismissal Date. I can do that with this... = Table.AddColumn(#"Renamed Columns4", "csActiveCaseDates", each {Number.From([csEnrollDa...
Hi,
Write this custom column formula in the Query Editor and name the column as Revised csDismissDate
=if [csDismissDate]=null then DateTime.Date(DateTime.LocalNow()) else [csDismissDate]
In your formula, refer to this newly created column.
pbrainardHelper III
Helper IIIPerfect. Thank you.
Ashish_Mathur
Super User
Super UserYou are welcome.