Forum Discussion
Devide amount over months
Hello,
Who can help me with the next question?
I have a table with trips
| Trip | Start | End | Amount |
| 1002201 | 15-1-2019 | 2-3-2019 | € 15.000,00 |
| 1002203 | 20-1-2019 | 30-1-2019 | € 45.000,00 |
| 1002205 | 15-2-2019 | 10-3-2019 | € 23.000,00 |
Now i want to devide the amount over the months depending the days that the project is in that month
Days
| Jan | Feb | Mrt |
| 16 | 28 | 2 |
| 10 | 0 | 0 |
| 0 | 13 | 10 |
Percentage
| Jan | Feb | Mrt |
| 35% | 61% | 4% |
| 100% | 0% | 0% |
| 0% | 57% | 43% |
The result has to be like this
| Jan | Feb | Mrt |
| € 5.217,39 | € 9.130,43 | € 652,17 |
| € 45.000,00 | € - | € - |
| € - | € 13.000,00 | € 10.000,00 |
Wiht kind regards
1 Reply
- Greg_Deckler
Community Champion
Take a look at these two Quick Measures as I think you want something like them.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365
