Identifying Last User

[PowerBI123456]

Hi,

I am trying to determine the last user who touched each account, but want to filter out any user that has "," in the name. 

So this would be the needed results:

I am dealing with 100,000s or rows. Thanks!!!

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[parry2k]

@PowerBI123456 try this measure

Last User = 
VAR __acct = MAX ( Touch[Account] )
VAR __lastTouchDate = 
CALCULATE ( 
    LASTNONBLANK ( Touch[Date of Action], 1 ), 
    Touch[Account] = __acct, 
    NOT CONTAINSSTRING ( Touch[User], "," ) 
)
RETURN
CALCULATE ( 
    MAX ( Touch[User] ), 
    Touch[Account] = __acct, 
    Touch[Date of Action] = __lastTouchDate 
)

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

[PowerBI123456]

@parry2k Thanks! Will this bring me back the name? I am justt getting a validate response for all them. Also, is there a way to do this in a seperate table? Want to use the values in my visuals.