Forum Discussion

smjzahid's avatar
smjzahid
Helper V
6 years ago

IF conditional checking with dates column not working

Hi 

 

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)

 

 

 

 

Need Help
Show and Tell

1 Reply

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    smjzahid try this measure

     

    Count Rows = 
CALCULATE ( COUNTROWS ( Table ), Table[Date] < TODAY(), Table[Date] <> BLANK() ) )

     

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!