calculate new and existing partner count during current period

[Anonymous]

Hi,

I've been looking around the community for something that might provide an answer to my problem. I am new to specifically DAX, and am trying to build dax.

Requirement.

 I need to count of particular partners for current year and previous year

Required output is as below:

[Anonymous]

Hi @amitchandak ,

I have checked above links and tried your dax but im not getting proper count.

I required New and Existing customer count and total count.

Implementation

We have 3 tables – Sales, customer master and master calender

Dax measures.

1. New Customer This Period = Sumx(VALUES(Customer_Master[CUSTOMERCODE]),if(ISBLANK([Rolling 9 before three]) && not(ISBLANK([Rolling 3])) , 1,BLANK()))

2. Existing Customer This Period = Sumx(VALUES(Customer_Master[CUSTOMERCODE]),if(not(ISBLANK([Rolling 3])) && not(ISBLANK([Rolling 9 before three])) , 1,BLANK()))

3. Rolling 3 = CALCULATE([TotalRevenue],DATESINPERIOD(Master_Calendar[Date],ENDOFMONTH(Master_Calendar[Date]),-3,MONTH))

4. Rolling 9 before three = CALCULATE([TotalRevenue],DATESINPERIOD(Master_Calendar[Date],eomonth(max(Master_Calendar[Date]),-3),-9,MONTH))

I got below output

Required output

[amitchandak]

@Anonymous , Current vs Previous

Power BI — Year on Year with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
https://www.youtube.com/watch?v=km41KfM_0uA

Customer Retention Part 1:
https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-1-Month-on-Month-Retention/ba-p/1361529
Customer 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

Customer Retention Part 5: LTD Vs Period Retention
https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-5-LTD-and-PeriodYoY-Retention-is-only/ba-p/2114497