Allocate values by months

[EvgenyZhutov]

Hi All.

Please help with tip for calculate cost allocation by months with accumulation.

Now i have this data set :

I need create visualization in Power BI  - transpose data and calculate accumulation value with summarize by month. 

For example :

Project life 12 month, cost will be allocate to 12 equals parts.

[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

[EvgenyZhutov]

Hi Dear.

No this is no helpful for me 😞

I need allocate them.

[Greg_Deckler]

Can you post your sample data as text? I don't want to type all of that.

[EvgenyZhutov]

yup 

NumberStart dateEnd dateCost

Project 1	01.09.2019	31.08.2020	52,3
Project 2	01.02.2019	31.01.2020	45,4
Project 3	01.04.2019	31.03.2020	46
Project 4	01.01.2020	31.12.2020	53,5
Project 5	01.07.2019	30.06.2020	51,1
Project 6	01.09.2020	31.08.2021	53,4
Project 7	01.01.2019	31.12.2019	46,7
Project 8	01.09.2020	31.08.2021	61,2
Project 9	01.03.2020	28.02.2021	52,1
Project 10	01.03.2020	28.02.2021	55,2
Project 11	01.06.2018	31.05.2019	35
Project 12	01.06.2018	31.05.2019	88
Project 13	01.02.2018	31.01.2019	46
Project 14	01.03.2018	28.02.2019	12
Project 15	01.04.2018	31.03.2019	22

[EvgenyZhutov]

up