Auto generate column when meet a condition

[trungduc5900]

 Hi there, 

I'm very new to the Power BI. 

Currently, I have a data set that content 2 column "Begin date" and "End date". I want to create multiple column which count number of date each month from "Begin date" to "End date", example as below:

Thank you in advance for your help.

[v-yuta-msft]

Hi trungduc5900,

Are there other columns like values in your table? And are there seperate values in each month in your table? Can you create a sample table with some dummy data for further analysis?

Regards,

Jimmy Tao

[trungduc5900]

Hi Jimmy,

Many thanks for your reply 

Basiccally, i was trying to allocate Contract value by month based on contract's duation. So i have a table with the following detail:

1. Customer name

2. Contract value

3. Contract begin date 

4. Contract end date.

The sample table would look like this 

[Ashish_Mathur]

Hi,

Please see if my solution here helps - Distribute projected revenue annually.

[v-yuta-msft]

Hi trungduc5900 ,

Could you clarify your logic about how to achieve allocate Contract value by month?

Regards,

Jimmy Tao