Converting DAX into Power Query

[vikas_patel81]

Hi, I've a dataset of construction schedule with actual & planned cost information.

My dataset have construction tasks in rows, along with information about planned start, planned end, actual start, actual end, and total planned and actual cost of that task.

As some of the tasks are in started status so they have actual start date mentioned but not the end date. I want to calculate the actual cost per day (based on actual start & end date), so want to create another column which says if the task is started but end date is blank then put today's date as end date.

I've created this successfully with DAX using below functions:

Conditional End date =

IF('Table'[actualEndDate]<>BLANK(),'Table'[actualEndDate}, 

IF(AND(ISBLANK('Table'[actualEndDate]), 'Table'[actualStartDate]<>BLANK(),TODAY(),BLANK()))

I now want that column to create a list in Power Query using custom column for other calculation, so want to recreate this in power query.

I've tried with below query, but getting error

if [actualEndDate] <> null then [actualEndDate] else
if [actualEndDate]= null & [actualStartDate] <> null then today() else null

Any help here will be really appreciated.

Thank you.

[Fowmy · Accepted solution]

@vikas_patel81 

You can add the following as a custom column in PQ:

if [actualEndDate]=null then Date.From(DateTime.FixedLocalNow()) else [actualEndDate]

[vikas_patel81]

Thanks so much. This worked. I see the mistake.