Forum Discussion
cottrera
Post Prodigy
Post ProdigyCountblank & Max
Hi The senerio is I have a table of repair jobs by agent, job age and comments. I want to know the Oldest (Max) Job age for any jobs with BLANK comments. I will be slicing the results by agent. ...
cottrera , Try a measure like
maxx(filter(Table, isblank(Table[Comments])),[Job])
amitchandak
Super User
Super Usercottrera , Try a measure like
maxx(filter(Table, isblank(Table[Comments])),[Job])
cottreraPost Prodigy
Post ProdigyWorks fine many thanks