I have a dataset which is having ID,Termination and Resignation and now I need the count of ID who have applied for resignation month wise and next is that I need to create an other measure in such a way that I need the cumulative difference from complete count of ID monthly.
Ex: If total 10 are there and 2 left on Jan I need Count as 8,if 3 left on feb I need count as 8-3=5 so on..
Below I provide the data set I am using in it Sheet 3 is to be focused.
I don't think you posted the correct excel. The excel you posted contains currency data. Or am I missunderstanding your problem?
I have the impression that your output-file didn't match to your example-file - it looked quite different.
Therefore it's not exactly clear what do you want to do but I assume it's some kind of measuring active / inactive ID's over the time. In general it should be possible with some if- respectively set analysis conditions which queries if the dates are smaller/greater respectively between your time-spans. But this approach could be quite difficult and might only work for certain measures/objects.
Quite common is therefore another approach which fills the NULL's from the termination with today() or yearend(today()) or something similar and used then an IntervalMatch to distribute it to real dates which are linked to a master-calendar. Afterwards you could use rather simple expressions like:
within a chart with a YearMonth dimension.
Does this input.
Give you this output?
I don't see how the logic? Please explain.