topic Re: DAX for Less than and greater than date in DAX Commands and Tips

DAX for Less than and greater than date

Userpath77 — Sun, 04 Jul 2021 04:24:08 GMT

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 days from today. Here is what I have, just not sure how to include the 45 day piece.

=Calculate(countrows(Elig_List),filter(Elig_List,Elig_List[Prom_Elig_date]-Today()<=60))

Thanks for any help!

Re: DAX for Less than and greater than date

Fowmy — Sun, 04 Jul 2021 10:39:08 GMT

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

Re: DAX for Less than and greater than date

Userpath77 — Sun, 04 Jul 2021 17:48:18 GMT

Thanks Fowmy. I tried but that measure doesnt populate on the visual-----it breaks the pie chart visual I have to use and says "cant display visual."

Re: DAX for Less than and greater than date

Userpath77 — Sun, 04 Jul 2021 18:25:10 GMT

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))