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 En...
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#M630
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