Forum Discussion
Cash Collection based on Sales
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!
1 Reply
Anyone here that can help out? 🙂
