I can't compare values over time like i would like.
I have queries to retrieve distinct resellers each month :Resellers QTD = var _max = maxx(ALLSELECTED(Revenue),Revenue[Period]) returnTOTALQTD(DISTINCTCOUNT('Partner'[Reseller Ref]),DATESQTD(Revenue[Period]),FILTER('Partner','Partner'[Date Validation] <=_max && 'Partner'[Date End] >=_max))Resellers Q-1 = var _max = maxx(ALLSELECTED(Revenue),Revenue[Period]) returnTOTALQTD(DISTINCTCOUNT('Partner'[Reseller Ref]),DATEADD(Revenue[Period],-1,QUARTER),FILTER('Partner','Partner'[Date Validation] <=_max && 'Partner'[Date End] >=_max))...
After i use my measures to retrieve diff net value:Net New QTD = [Resellers QTD]-[Resellers Q-1]Net New Q-1 = [Resellers Q-1]-[Resellers Q-2]...
Now i would like to retrieve the distinct NEW resellers.This mean if i have a DISTINCT('Partner'[Reseller Ref]) exists @ QTD but not present in Q-1, i would like to count him.
I tried something like this but it seems not working:
Expension Q-1 =CALCULATE([Resellers Q-1],FILTER('Subscription Partner', [Resellers Q-1] <> [Resellers Q-2]))
Any idea ? I don't want the NET NEW !
Go to Solution.
@Anonymous , Check these two blog on customer retention can help you get what you need
Customer Retention Part 1:https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-1-Month-on-Month-Retention/ba-p/1361529Customer Retention Part 2: Period over Period Retention :https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-2-Period-over-Period-Retention/ba-p/1377458
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
View solution in original post
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.