Forum Discussion
Count the IDs accumulated
Hello everyone, Could you please help me with the following? The following table has an ID and finish date when one ID wasn't finish the closed date is blank. Now I want to count the lines th...
Hi,
Write this calculated column formula
Column = COALESCE(CALCULATE(COUNTBLANK(Data[Closed Date]),FILTER(Data,Data[Finish Date]<EARLIER(Data[Finish Date]))),0)Hope this helps.