problem

[Anonymous]

I have created a calculated column:

"Week of year = WEEKNUM(DateTable[Date],1)", then I have created another calculated column

[v-piga-msft · Accepted solution]

Hi @Anonymous,

You could create the measure below to get your right output.

Measure 2 =
VAR temp =
    MAXX (
        TOPN (
            1,
            SUMMARIZE (
                'S P H D',
                DateTable[Week Range],
                'DateTable'[Fiscal Year],
                'DateTable'[Month],
                "CountMRN", COUNT ( 'S P H D'[MRN] )
            ),
            [CountMRN], ASC
        ),
        [Week Range]
    )
RETURN
    CALCULATE (
        MIN ( 'DateTable'[N D t W E] ),
        DateTable[Week Range] = temp
    )

This measure calculates the date next to the week range of the min count of MRN.

Hope this can help you!

Best Regards,

Cherry

[v-piga-msft · Accepted solution]

Hi @Anonymous,

Based on your private letter, we know that you have solved the problem with my DAX. I will mark the reply to close the thread.

Best Regards,

Cherry

[v-piga-msft · Accepted solution]

Hi @Anonymous,

You could create the measure below to get your right output.

Measure 2 =
VAR temp =
    MAXX (
        TOPN (
            1,
            SUMMARIZE (
                'S P H D',
                DateTable[Week Range],
                'DateTable'[Fiscal Year],
                'DateTable'[Month],
                "CountMRN", COUNT ( 'S P H D'[MRN] )
            ),
            [CountMRN], ASC
        ),
        [Week Range]
    )
RETURN
    CALCULATE (
        MIN ( 'DateTable'[N D t W E] ),
        DateTable[Week Range] = temp
    )

This measure calculates the date next to the week range of the min count of MRN.

Hope this can help you!

Best Regards,

Cherry