Forum Discussion

Userpath77's avatar
Userpath77
Icon for Helper II rankHelper II
5 years ago

DAX for Less than and greater than date

Hello All   Probably a simple fix, but I can't figure it out. I have a column of dates and I just need a measure that counts how many dates are:   60 days or less than today, but greater that 45 ...
Need Help
Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
5 years ago

Try this measure please:

Count Days = 
var __today = TODAY()
var __result = 
    CALCULATE(
        COUNTROWS( Elig_List ),
        Elig_List[Prom_Elig_date] >= (__today + 45) && Elig_List[Prom_Elig_date] <=  (__today  + 60) 
    )
return
    __result
Userpath77's avatar
Userpath77
Icon for Helper II rankHelper II
5 years ago

I modified my original to this and it worked perfect:

 

CALCULATE(countrows(Elig_List),filter(Elig_List,Elig_List[Prom_Elig_Date]-TODAY()<=60),filter(Elig_List,Elig_List[Prom_Elig_Date]-TODAY()>45))