Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

CALENDARAUTO() Bug

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?
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    6 years ago

    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.

1 Reply

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    6 years ago

    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.