Forum Discussion

Datavizuserpbi's avatar
Datavizuserpbi
Icon for Helper I rankHelper I
3 years ago
Solved

If date between two dates get the value by year

HI,   I create a measure to check if the date is between 2 dates.  IF(SELECTEDVALUE(DateTable[Date])>=date_min && SELECTEDVALUE(DateTable[Date])<=date_max,1,0) When i have the top 3 month of th ...
Need Help
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, Datavizuserpbi 

     

    You can try the following methods.
    Measure:

    Result = 
 Var _count1=COUNTX(FILTER(ALL('Table'),[Year]=SELECTEDVALUE('Table'[Year])&&[Measure]=1&&[Month]<=3),[Measure])
 Return
IF(_count1=3,0,1)

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

Use REMOVEFILTERS against the Month column and return the MAX value.

Datavizuserpbi's avatar
Datavizuserpbi
Icon for Helper I rankHelper I
3 years ago

Mayebe I don't understand but I can't use Max with a measure 

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    3 years ago

    You can when you iterate through it.  Via MAXX for example.