Forum Discussion
smjzahid
Helper V
6 years agoIF 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 (> tod...
parry2k
Super User
6 years agosmjzahid 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!