Forum Discussion

HenryJS's avatar
HenryJS
Post Prodigy
6 years ago
Solved

Measure: Count IF Date

Hi all,   How do I create a measure that:   Counts 'Has JobRef on Advert Export?' IF 'Export Adverts.Closing Date' is past today AND 'JobStatus' is ' Open'?     Thanks,   Henry
Need Help
Show and Tell
Tips and Tricks
amitchandak's avatar
amitchandak
Super User
6 years ago

Try new measure

calculate(count(table[Has JobRef on Advert Export?]),table['Export Adverts.Closing Date']<today() , table[JobStatus]="Open")

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin