Hi,
I have a monthly snapshot of our member data, and am trying to create a measure showing the income effects of members joining / leaving / dying etc.
For example, members who have died in the month are identified by a flag column, Died_Flag. I would like to calculate the income for this...