Forum Discussion
smjzahid
6 years agoHelper V
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 (> tod...
parry2k
6 years agoSuper User
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!