cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
smjzahid
Helper IV
Helper IV

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)

 

image.png

 

 

 

1 REPLY 1
parry2k
Super User
Super 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!






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors