Need help with Excel formula

[anu2021]

Hi, I need a help with excel formula and below is the scenario,

Data exisiting in the format , Basis the start date M1 will be considered and items count is given
Start Date	End Date	Month1	Month2	Month3	Month4	Month5	Month6	Month7	Month8	Month9	Month10	Month11	Month12
1-Jan-25	31-Dec-25	1	1	1	1	1	1	1	1	1	1	1	1
1-Apr-25	31-Aug-25	1	1	1	3	3
16-Jun-25	31-Jan-26	1	1	1	1	1	2	2	3

Desired Output - Basis the start the date header Month values to be derived and item count to be update in corresponding months
Start Date	End Date	Jan-25	Feb-25	Mar-25	Apr-25	May-25	Jun-25	Jul-25	Aug-25	Sep-25	Oct-25	Nov-25	Dec-25	Jan-26
1-Jan-25	31-Dec-25	1	1	1	1	1	1	1	1	1	1	1	1
1-Apr-25	31-Aug-25				1	1	1	3	3
16-Jun-25	31-Jan-26						1	1	1	1	1	2	2	3

[v-karpurapud]

Hi @anu2021 

We have not received a response from you regarding the query and were following up to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank You.

[v-karpurapud]

Hi @anu2021 

Thank you for reaching out to the Microsoft Fabric community forum.

I would also like to thank you @amitchandak  and @Ashish_Mathur  for your active participation and for sharing solutions within the community forum. 

I hope the information provided helps resolve your issue. If you have any further questions or need additional assistance, please feel free to contact us. We are always here to help.

Best regards,
Community Support Team. 

[Ashish_Mathur]

Hi,

Post your Excel question here - Microsoft 365 and Office Excel For business Windows - Microsoft Q&A.  This is the PowerBI forum.

[amitchandak]

@anu2021 , There are two type of solution 

First One Cohort analysis 

Power BI Cohort Analysis, Customer Retention %- https://youtu.be/qY1SDF1cwsg
https://community.powerbi.com/t5/Quick-Measures-Gallery/Customer-Retention-Part-3-Period-Of-Stay-Coh...

Second one between dates 

Measure way
Power BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzM

month between range/month between range
https://amitchandak.medium.com/power-bi-power-query-vs-dax-months-between-range-df019cec823b