Total New customers based on transactions table

[DenisStyrt]

Hi All,

I would really appreciate some help to calculate new customers per quarter based on the following transactions table:

I only know if a customer is new if he didn't exist in the previous quarter.

[amitchandak · Accepted solution]

@DenisStyrt , In case you have date then use datesqtd and follow my blog

https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-1-Month-on-Month-Retention/b...

replace datesmtd with datesqtd

If not then create a qtr rank and formula like

new column
Qtr Rank = RANKX(all('Date'),'Date'[Qtr Start date],,ASC,Dense)

Measures
This Qtr = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Qtr Rank]=max('Date'[Qtr Rank])))
Last Qtr = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Qtr Rank]=max('Date'[Qtr Rank])-1))

formulas are same as given in blog