Need help on a DAX to obtain Cohort Start Date

[Anonymous]

Hi, 

I need to find the Cohort started month with the data look like this. The rank is the order of the month that the student is still studying with the center. I need to find the first month for each ENR ID (enrollment ID).

For example, in this case, I need all of the Cohort Started Month to be 2020-01-02 for this student.

I really need help with this. Thank you!!!

[amitchandak · Accepted solution]

@Anonymous , Try a column like

new column =

minx(filter(table, [enr id] =earlier([enr id])),[Month])

Similar stuff has been discussed here

https://youtu.be/Q1vPWmfI25o

[v-alq-msft · Accepted solution]

Hi, @Anonymous 

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

Table:

You may create a calculated column or a measure as below.

Calculated column:

Cohort Started Month = 
CALCULATE(
    MIN('Table'[Month]),
    FILTER(
        ALL('Table'),
        'Table'[ENR ID]=EARLIER('Table'[ENR ID])
    )
) 

Measure:

Cohort Started Month Measure = 
CALCULATE(
    MIN('Table'[Month]),
    FILTER(
        ALL('Table'),
        'Table'[ENR ID]=SELECTEDVALUE('Table'[ENR ID])
    )
) 

Result:

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi guys,

Thank you so muchhh !!! They all worked perfectly 😍

[amitchandak · Accepted solution]

@Anonymous , Try a column like

new column =

minx(filter(table, [enr id] =earlier([enr id])),[Month])

Similar stuff has been discussed here

https://youtu.be/Q1vPWmfI25o