Forum Discussion
Simple Loop
Hi team, Can you please assist? Im unsure if such a thing is possible in Powerbi, but can we do looping? Basically i have a table, sample data shown below, showing all the incomes per customer an...
Hi SammyNed
I have a few questions. Can you please make them clearer?
1. Does every customer have only one income value in the table? With only one income value, the problem will be easier. However, if a customer has multiple income values, we need to know from which date we starts to count the expenses. And we need to count based on the total income or on every single income?
2. According to the sample final result, do you only need to count the expenses happening after an income value and ignore the ones previous of that?
Best Regards,
Community Support Team _ Jing