Spread Value over dates range and have information about the month and year

[BIDeveloper_]

Hello,

I am stuggeling with some logic how to implement...

This is my data:

Name	Phase	Date Start		Date End		Value
A	1	15.05.2020		30.06.2020		10
A	2	30.06.2020		31.01.2021		15
A	3	31.01.2021		30.04.2021		5
B	1	20.12.2020		31.07.2021		20
B	2	31.07.2021		31.08.2021		5

What I would like to achive is the receive sum of value per month and year for particual phase for the specific name has occured.

In example for A, phase 1 and 2 I would like to achive this information:

Name	Month (Period) and Year	Value
A	P05 2020	10
A	P06 2020	10
A	P07 2020	15
A	P08 2020	15
A	P09 2020	15
A	P10 2020	15
A	P11 2020	15
A	P12 2020	15
A	P01 2021	15

Phase 1 start 15 may but it is not important if this will be daily value or monthly. Because of that I wrote 10 in May 2020.

Does anyone has ANY idea how to do that or if it is POSSIBLE?

Thank you for reading my post.

[amitchandak · Accepted solution]

@BIDeveloper_ , you need to have a date table with the month

one approach I discussed here

https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-o...

Another one can be found in the attached file. You need to handle when can you have period based on date

[BIDeveloper_]

Thank you so much!

Your post and fiels are very simple to read. This will help me!

Thank you for sharing the knowladge