Help! - A measure to find the people recently logged in.

[Anonymous]

My Data looks like this -

I'm trying to find out the people/user-id recently logged in for the recent date.(that are currently inside the building)

A person can have multiple ins and outs.

Any help would be really great.

Thanks,

Anand!

[Icey]

Hi @Anonymous ,

Try this:

Recent log in =
CALCULATE (
    MAX ( 'Table'[SCAN_DATE_TIME] ),
    ALLEXCEPT ( 'Table', 'Table'[USER_ID], 'Table'[SCAN_TY] )
)

 

Best Regards,
Icey

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

[Anonymous]

Thanks for your reply.

Since I have multiple Ins and Outs(which is filtered in the picture that I posted) I would like to see the people who are currently inside.

I believe I should compare the max value for in and out ; then if max in is greater that max out - I should be able to name that person as "currently in"

How do I do that?

[Anonymous · Accepted solution]

@Anonymous - Try this measure:

In Building =
var _MaxIn = CALCULATE (
    MAX ( 'Table'[SCAN_DATE_TIME] ),
    'Table'[SCAN_TY] = "IN"
)
var _MaxOut = CALCULATE (
    MAX ( 'Table'[SCAN_DATE_TIME] ),
    'Table'[SCAN_TY] = "OUT"
)
return _MaxIn > _MaxOut

Create a table visual with the user info and filter it by this new measure.

I hope this helps. If it does, please Mark as a solution.
I also appreciate Kudos.

[Anonymous]

Works!