Cash Collection based on Sales

[MrMP]

Hi,

I have a following table structure

Month	Sales
January	100
February	200
March	300

This is the input for power bi. I need to create measures so i can have table structure like following:

Month	Begining balance measure	Sales	Collection %  (50%) measure	Ending balance measure
January	0	100	50	50 (0+100-50)
February	50	200	125 (250*0.5)	125 (200+50-125)
March	125	300	150	275 (125+300-150)

Thank you!

[MrMP]

Anyone here that can help out? 🙂