IF conditional checking with dates column not working
I am connected to the sharepoint list from PBI desktop and I have column of type DATE named (Expiry Date). This column stores dates that are historical (< Today's date) and Future Date (> todays date). I want to write a measure that counts how many of my granted dates are less than today's date only and they are not blank (There are rows with blank or null values) I dont want to count those.
As per below snip what I expect from my measure is to give me 5 as you can see (5 rows contains dates that are less than today's date) I dont want to count any future date (dagte greater than today's date and blank rows)