The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Guys, I want to do a cohort analysis where I count the number of hits that each software had per month to find out if customers are accessing the software or decreasing the amount of access. Each row in the columns is an access. The result should be like the example of the print on the right side.
@Sandro , refer if these can help
https://finance-bi.com/power-bi-cohort-analysis/
http://funbiworld.com/2019-12-02-cohort-analysis/
https://www.youtube.com/watch?v=tuk1CrigTSI
SEGMENTATION
https://www.daxpatterns.com/dynamic-segmentation/
https://www.daxpatterns.com/static-segmentation/
https://www.poweredsolutions.co/2020/01/11/dax-vs-power-query-static-segmentation-in-power-bi-dax-po...
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization
User | Count |
---|---|
15 | |
12 | |
8 | |
7 | |
7 |
User | Count |
---|---|
24 | |
20 | |
12 | |
9 | |
7 |