Forum Discussion

Datavizuserpbi's avatar
Datavizuserpbi
Helper 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 year equal to 1 the result for the year is equal to 0 because the condition take the result of the last month of the year.
 
MeasureYearColumn A
02021A

 

MeasureYearMonthColumn A
1202101A
1202102A
0202103A

 

How to fix the problem and make the result to 1 for 2021 ?

 

Thank

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.

     

4 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

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

      • lbendlin's avatar
        lbendlin
        Super User
        3 years ago

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

  • v-zhangti's avatar
    v-zhangti
    Community Support
    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.