Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Allan Blain]

I know this should be easy but ……… I have a date column that should be filled in and is empty and the query returns null. I’d like to use the replace null function in the query editor to replace the nulls with random dates between today and some future date. When I try adding the power query formula I get an error message asking me to enter a specific date.

——————————
Allan Blain
Project Manager
Portland OR
2052135310
——————————

[Del Swingle]

Allan,
As a suggestion, you could create a new custom column that looks at the original Date column and use an if statement similar to the following:

 if [Date]=null then
Number.RandomBetween(Number.From(DateTime.LocalNow()),Number.From(Date.AddDays(DateTime.LocalNow(),365)))
else  [Date]

This will look for any nulls in you Date column and generates random date between today and 1 year from now and copy any values not null. This will return a date serial number so you’ll need to convert this new column to type date.

Hopefully this helps,

——————————
Del Swingle
WA
——————————
——————————————-