Forum Discussion
DAX - How to Count the Consecutive Occurrences
Hi There; I would like to count the consecutive worked days for a group of employees, I have a table of employee work date, employee ID, employee name as shown below and I wont to identify who worke...
Hi mahoneypat , I am trying to use your measure above and it is not working. I am wondering if it is due to the last statement?
IF ( COUNTROWS ( 'Work' ) > 0, IF ( diff > 1, diff ) )
Is the true statement missing from the first part and the false statement missing from the second statement?
IF ( COUNTROWS ( 'Work' ) > 0 [True missing], IF ( diff > 1, diff ), [False missing] )
mahoneypat
Microsoft Employee
Microsoft EmployeeWith the IF function, if you don't provide a false option, it returns blank. The expression is complete, accepting the default BLANK() for both falses.
Pat