Forum Discussion

felipevaz's avatar
felipevaz
Icon for Helper I rankHelper I
6 years ago

CALCULATE IF DATE GREATER THAN

Hi folks,

 

Please, I am trying to get a CALCULATE  using 2 variable, depending if the date is greater than...

 

I tried but not working

IF( [DATE] > DATE(2019;10;1) ; CALCULATE(DISTINCTCOUNT(ID;FILTER(MYTABLE;MYTABLE[%]>0,8); CALCULATE(DISTINCTCOUNT(ID;FILTER(MYTABLE;MYTABLE[%]>0,5))

 

Could you help me?

Need Help

1 Reply

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    6 years ago

    felipevaz seems like you are adding this as a measure, you need to change the expression as below, if it doesn't work, please explain if there is an error or you are getting wrong result, simply saying it is not working, very hard to know what does that means.

     

    IF( MAX( Table[DATE] ) > DATE(2019;10;1) ; CALCULATE(DISTINCTCOUNT(ID;FILTER(MYTABLE;MYTABLE[%]>0,8); CALCULATE(DISTINCTCOUNT(ID;FILTER(MYTABLE;MYTABLE[%]>0,5))