Is there a date function in Power Query which supports Query Folding resulting in CURRENT_DATE?

[TokyoBI]

Is there a date function in Power Query which supports Query Folding? When I currently use a date function the query does not fold anymore. 

The following M-code is used to create a new custom column:

= if [End Data] = NULL then DateTimeZone.FixedUtcNow() else [End Date]

I would like to fold this into something like this

case
when "_"."End Date" is null
then CURRENT_DATE
else "_"."End Date"
end

[Daryl-Lynch-Bzy]

@TokyoBI - I am a big fan of Query Folding, but I am also conscious that it probably won't matter if you import all the data from the Server to the Power BI Client and then add the Current Date.  You may want to use Phil Seamark analysis my refresh Power BI / SQL Profiler to see if there is actually a performance benefit.

The second thing is that I am not really a fan of having the Current Date repeated on every row of the Table.  What is the benefit?  Just a create a second table with 1 row and the current date.  The Data Model will be smaller and this approach is unlikely to impact your reports.

@ImkeF 

[TokyoBI]

Thanks for the feedback. How would you implement it to use the current date when a date field is empty so that the native (SQL) query folds?

The following M-code is used to create a new custom column:

= if [End Data] = NULL then DateTimeZone.FixedUtcNow() else [End Date]

I would like to fold this into something like this

case
when "_"."End Date" is null
then CURRENT_DATE
else "_"."End Date"
end

[ImkeF]

To my understanding, you can do a lot of transformations in a new column without breaking query folding. 
Just don't try to change an existing column.

[ImkeF]

Hi @TokyoBI ,
instead of transforming an exising column, try adding a new one that applies the date conversion and then delete the old one.

[TokyoBI]

I would like to perform a transformation which includes the current date; not just a type conversion.