Forum Discussion
Need help with Excel formula
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 |
4 Replies
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-Cohort-Analysis/m-p/1393332#M630Second one between dates
Measure way
Power BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzMmonth between range/month between range
https://amitchandak.medium.com/power-bi-power-query-vs-dax-months-between-range-df019cec823bHi,
Post your Excel question here - Microsoft 365 and Office Excel For business Windows - Microsoft Q&A. This is the PowerBI forum.
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.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.
