Custom Column for First Time Fix

[Anonymous]

Hello,

Could someone help me with a first time fix custom column please?

Start Date

Fix Date

=IF fixdate is equal to Start date then Yes else no. 

Thanks, 

[v-jingzhang · Accepted solution]

Hi @Anonymous 

You can create a calculated column with below DAX

First time fix column =
IF (
    MINX (
        FILTER (
            'Table',
            'Table'[job] = EARLIER ( 'Table'[job] )
                && 'Table'[Fix Date] <> BLANK ()
        ),
        'Table'[Fix Date]
    ) = 'Table'[Fix Date],
    "Yes",
    "No"
)

If this cannot get what you want, can you provide some sample data and expected result to help us understand your requirement better? 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[Anonymous]

Hi,

Is this correct, its coming up with an error?

IF ( MINX ( FILTER ( [Task Created Date] = EARLIER ([Task Created Date] ) && [Fix Date] <> BLANK () ), [Fix Date] ) = [Fix Date], "Yes", "No" )