I wonder if you can help me here.
I have this table with codname and LastProccessDate. Attach.
If you count the people that LastproccessDate = 31/12/2020 you will have 23.
Although you don’t have any with LastproccessDate = 30/11/2020, you should have the same 23. And if you going down to july it’s the same number, except july that you should have 24 and in june, 26. In the 31st of january of 2019 you should have 32 people.
Is there any dax formula to do this?
I hope i was clear enough.
Thanks a lot
Book1.xlsx (10.1 KB)