CALENDARAUTO() Bug

[Anonymous]

I'm trying to make a PBI template file with a pre-loaded dim_Date unfortunately the following DAX expression returns an error:

dim_Date =

IFERROR (

CALENDARAUTO (),

CALENDAR ( DATE ( 2019, 01, 01 ), DATE ( 2019, 12, 31 ) )

)

There appears to be a bug where a CALENDARAUTO() error is not caught/short-circuits IFERROR() and ISERROR().  Does anyone know of a workaround or a way to highlight this to the product team?

[v-yuta-msft · Accepted solution]

@Anonymous ,

The return value of IFERROR() should be a scalar of the same type as the parameter. So the first and second parameter of IFERROR() should be an scaler value, not a table.

Please refer to:

https://docs.microsoft.com/en-us/dax/iferror-function-dax

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.