Forum Discussion

nehajadhav166's avatar
nehajadhav166
Resolver I
4 years ago
Solved

Error with AverageX

Hi Experts,   I have created measure : Cpk = Var selected_Value=SELECTEDVALUE(TestData[Name]) Var selected_Char=SELECTEDVALUE(TestData[Characteristic.Name]) Var selected_maxdate=IF (ISFILTE...
Need Help
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi nehajadhav166 
    Calendar funtion works normally inside measures. You can also replace it with DATESBETWEEN and see if the result changes.

  • tamerj1's avatar
    tamerj1
    4 years ago

    nehajadhav166 
    I mean 

    && RFLoopback[Date] IN DATESBETWEEN ( RFLoopback[Date], selected_mindate, selected_maxdate )
nehajadhav166's avatar
nehajadhav166
Resolver I
4 years ago

tamerj1  yes in original measure I used same and then I am getting error.Is there any other way yo handle this?

 

Thanks,

Neha

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    nehajadhav166 
    I mean 

    && RFLoopback[Date] IN DATESBETWEEN ( RFLoopback[Date], selected_mindate, selected_maxdate )