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, 0...
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.

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.