Filtering based on the earliest timesptamp by creator name

[datanau001]

Dear all,

What I'm trying to do is to show a column or a measure containing just the ealiest timestamp of an activity created by a person (Activity Creator) in the ticket.

I've been looking at some existing topics with similar requests but I did not manage to create it.

See below sample:

So, in the last column (First Activity), this information (earliest timestamp) from Activity Creation Date and based in the Activity creator.

Could you please help with it?

Thank you.

Marcelo

[v-frfei-msft · Accepted solution]

Hi @datanau001,

I made one sample for your reference. Here we need to create a measure as below to achieve your goal.

First Activity = 
VAR mindate =
    CALCULATE (
        MIN ( Activity[Activity Creation Date] ),
        ALLEXCEPT ( Activity, Activity[SR Number] )
    )
RETURN
    IF (
        MAX ( Activity[Activity Creation Date] ) = mindate,
        MAX ( Activity[Activity Creation Date] ),
        BLANK()
    )

For more details, please check the pbix as attached.

Regards,

Frank

[v-frfei-msft · Accepted solution]

Hi @datanau001,

I made one sample for your reference. Here we need to create a measure as below to achieve your goal.

First Activity = 
VAR mindate =
    CALCULATE (
        MIN ( Activity[Activity Creation Date] ),
        ALLEXCEPT ( Activity, Activity[SR Number] )
    )
RETURN
    IF (
        MAX ( Activity[Activity Creation Date] ) = mindate,
        MAX ( Activity[Activity Creation Date] ),
        BLANK()
    )

For more details, please check the pbix as attached.

Regards,

Frank

[v-frfei-msft · Accepted solution]

Hi @datanau001,

Does that make sense? If so, kindly mark my answer as a solution to close the case.

Regards,
Frank

[datanau001]

Hello Frank, it is exactly what I was looking for!

Thank you very much.

Marcelo