Forum Discussion

ErickMontiel's avatar
ErickMontiel
New Member
2 years ago

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...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
2 years ago

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.