Forum Discussion
cohort
leela77 ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Check if this can help
Cohort Analysis: https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-3-Period-Of-Stay-Cohort-Analysis/ba-p/1393410
Power BI Cohort Analysis, Customer Retention %- https://youtu.be/qY1SDF1cwsg
Thank you very much for the links, amitchandak; however, I couldn't work it out with my set of data. Please find the dataset here: https://www.dropbox.com/scl/fi/qtfa8f8lfbzkhuy9jxyfu/sample.pbix?rlkey=s8dbz3a4mk85kd0a2zmsgboe7&dl=0
an additional note:
SQL is being calcualted:CALCULATE (
DISTINCTCOUNT ( fact_pipeline_events[pipeline_journey_id] ),
fact_pipeline_events[total_opportunity_created_events] > 0,
dim_product[business_unit_reporting] = "XYZ"
)
)
SQO is being calculated:
CALCULATE(
[# Opps Created - Discovery],
dim_product[product_name] = "xyz"
)