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...
Hello, thank you for the help.
I put the formula and it calculates the blank lines but for the same date, not the blank lines for previous dates. Could you help me again?
Hi ErickMontiel
The line inside FILTER that compares
MyTable[Finish Date] = CurrentFinishDate
should be
MyTable[Finish Date] <= CurrentFinishDate
or
MyTable[Finish Date] < CurrentFinishDate
Let me know how this goes.