Forum Discussion

ViorelCa's avatar
ViorelCa
Icon for Helper I rankHelper I
9 years ago

DAX Measure reference error

Dear Colleagues,   I get an error when I am referencing the following Measure.   CurrentMonth:=CALCULATE( MONTH(Max(Merge1[Date])), Merge1[SalesR2017]<>0)   The value of this CurrentMonth mea...
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi ViorelCa

 

Try this one:

Measure = CALCULATE(
                                       sum(Merge1[SalesR2017]),
                                       MONTH(Merge1[Date])=MONTH(Max(Merge1[Date]))
                    )
ViorelCa's avatar
ViorelCa
Icon for Helper I rankHelper I
9 years ago

Hi Anonymous

 

The same error.

 

Actually I am doing this in PowerPivot Excel 2013 and the error does not not have a message, it just shows #ERROR