Forum Discussion

katieandemil's avatar
katieandemil
Frequent Visitor
6 years ago

Why do I get this DAX error

Hi, I would like to understand why I get an error when I try to filter date field from reporting date dimension using my fact table field Due Date. This variable SequenceResultWithError returns this...
Need Help
v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

Hi katieandemil ,

 

We can just delete the variable with error, it cannot recogenize 'Forest'[Due Date] as a constant value in filter of calculate funcion.

 

Column = 
VAR DueDate = [Due Date]
RETURN
    CALCULATE (
        MAX ( 'Reporting Date'[Working Day sequence] ),
        'Reporting Date'[Date] = DueDate
    )

 

After using a var to save the value of [Due Date] column, it will be treated as a constant value and can be used in the filter.

 

 


BTW, pbix as attached.

 

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.