QUARTELY COHORT ANALYSIS?

[Andrew_na_lang]

I have a cohort analysis which is typically montly. 

My boss wants it quarterly. 
I created calculated column to group our customers : 

(DATE) ORDER QUARTER & YEAR =

VAR _FirstOrderDate = CALCULATE(
MIN(orders[time_dropoff_id]),
FILTER(
ALL(orders),
orders[customer_id] = EARLIER(orders[customer_id]) &&
NOT orders[order_status_code] IN {7, 10, 2.5}
)
)
VAR _Year = YEAR(_FirstOrderDate)
VAR _Quarter = QUARTER(_FirstOrderDate)
VAR _MonthEndOfQuarter = _Quarter * 3
VAR _LastDayOfQuarter = EOMONTH(DATE(_Year, _MonthEndOfQuarter, 1), 0)
RETURN _LastDayOfQuarter

I created series that will serve as my column 

Quarter_After = GENERATESERIES( 0, 1000, 1 )


I need DAX where I want know how many from cohort  0 is left quarter by quarter similar to my monthly cohort :

 My monthly cohort retention dax is like this: 

Current Retention Value =

VAR currentMonthsAfter = SELECTEDVALUE('Months after'[Value])

VAR currentfirstordermonth = SELECTEDVALUE( orders[(DATE) FirstOrderMonthYear])

RETURN

    CALCULATE(

        DISTINCTCOUNT( orders[customer_id] ),

        FILTER(

            orders ,

            EOMONTH( orders[time_dropoff_id].[Date] , 0 ) = EOMONTH( currentfirstordermonth , currentMonthsAfter )))

[v-shex-msft]

Hi @Andrew_na_lang ,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng