Date Filtering in slice Not Working

HI…
i am trying to Filter date as:
All Rows till todays date of last year
AND
All Rows after 1st April of current Year…

I tried these two Expressions but they are not giving me results…

and([date]<=date(concatenate(month(today()),"/",DAY(TODAY()),"/",Year(today())-1)),
[date]>=date(concatenate(4/1,"/",Year(today()))))

and(([Date]>=any(select(Table[date],[date]=date(concatenate(4/1,"/",Year(today())))))), ([Date]<=any(select(Table[date],[date]=date(concatenate(month(today()),"/",DAY(TODAY()),"/",Year(today())-1))))))

Both these expressions are not giving any results. Instead if i try one part of expression in slice say ([date]<=date(concatenate(month(today()),"/",DAY(TODAY()),"/",Year(today())-1) it works perfectly… Please tell me where i am wrong and why the expression isnt working as expected… Thanks in Advance

Any single record cannot be BOTH before 1 year ago, AND after April 1st of this year.

Sounds like you’re wanting OR() instead of AND()

3 Likes

@Marc_Dillon

OOPS!!!.. You are absolutely Correct… Thanks a ton… Solved it…

2 Likes