Show latest date in table - show blank if possible

[non23]

hey guys, I have a data that looks like below:

and I want to show the latest time-out date, but if it's blank then it should show blank instead of the other log-out time like below:


Appreciate any help! 

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your semantic mode looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

Earliest timein: = 
MINX (
    SUMMARIZE ( data, user[user], data[time_in] ),
    CALCULATE ( MIN ( data[time_in] ) )
)

Latest timeout: =
VAR _t =
    SUMMARIZE ( data, user[user], data[time_in] )
VAR _result =
    MAXX ( _t, CALCULATE ( MAX ( data[time_out] ) ) )
VAR _condition =
    COUNTROWS ( FILTER ( _t, CALCULATE ( MAX ( data[time_out] ) ) = BLANK () ) ) > 0
RETURN
    IF ( _condition, BLANK (), _result )

[Moetazzahran · Accepted solution]

Hello @non23 , 

If I understand correctly, you want the earliest timein and latest timeout per user in two different measures. 

Earliest TimeIn =

CALCULATE(

    MIN('Table'[TimeIn]),

    ALLEXCEPT('Table', 'Table'[User])

)

Latest TimeOut =

SWITCH(True(),

    ISBLANK( CALCULATE(

        MAX('Table'[TimeOut]),

        ALLEXCEPT('Table', 'Table'[User])

    )),

    BLANK(),

    VAR parallelvalue=CALCULATE(

        MAX('Table'[TimeIn]),

        ALLEXCEPT('Table', 'Table'[User])

    )

    RETURN

    CALCULATE(MAX('Table'[TimeOut]),ALLEXCEPT('Table', 'Table'[User]),'Table'[TimeIn]=parallelvalue)

)

Please let me know if this serves the purpose. And accept it as a solution if it solves your problem. 

You Kudos is much appreciated. 

Thank you

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your semantic mode looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

Earliest timein: = 
MINX (
    SUMMARIZE ( data, user[user], data[time_in] ),
    CALCULATE ( MIN ( data[time_in] ) )
)

Latest timeout: =
VAR _t =
    SUMMARIZE ( data, user[user], data[time_in] )
VAR _result =
    MAXX ( _t, CALCULATE ( MAX ( data[time_out] ) ) )
VAR _condition =
    COUNTROWS ( FILTER ( _t, CALCULATE ( MAX ( data[time_out] ) ) = BLANK () ) ) > 0
RETURN
    IF ( _condition, BLANK (), _result )