Bug in March 2023 Power BI Desktop Update - new error in calculated column that didn't exist before

you might try this formula instead, which doesn't require an IF statement/branching.
Is Before Date = 'tabular AllDate'[DateKey] < TODAY()

Thanks, I've tried that and get the same error:

It seems to be an issue when using Today() or Now(), if I change it to compare to another date column, it doesn't throw a warning.

We also confirmed this error doesn't existe when using the Power BI Desktop February 2023 version (or prior). This isn't a new calculated column and only throws an error in the new Power BI Desktop March 2023 version.

Hi nkane ,

I have reproduced your problem, I will investigate it in following days, if there is any progress I will update here. As a workaroud, you can temporarily use DATE function in the report, it works fine by my test.

Best regards,

Community Support Team_kalyj

Got the same errors.

Got using a published dataset in DirectQuery mode.
When making a calculated column using the TODAY() function makes the error.
It worked fine till the march update.

Older then 2 weeks = 
IF(
DATEDIFF(TODAY(), orders[OrderDate], DAY) >14,

"Yes",
"No",
)

I also have this error when in Direct Query.

DAX:

DaysSinceOrderPlaced = DATEDIFF('Transaction Lines'[Date], TODAY(), DAY)

I am having the same issue with Today().  Today I discovered that FORMAT() also causes the same exception.

Is there any progress on a bug fix?

Any date function between 2 sources in DirectQuery mode generates the error.
Using a hard date isn't a workable fix, because I have to update it every day.

Hi nkane ,

The issue is fixed in the latest version 2.115.1006.0 64-bit (March 2023), please update and try again.

Best regards,

Community Support Team_yanjiang

👍

I'm running Version: 2.115.663.0 64-bit (March 2023) on our VM, and when I go to update via the "Update available" link in Power BI, it takes me to a February version.