Devide amount over months

[Anonymous]

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

[Greg_Deckler]

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