Forum Discussion
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
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
2 Replies
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
