Calculate a column that give the most recent date

[Anonymous]

Hi Power BI community

I would like to ask for your help.

I have a file that gives me the last activity of each users, on several services (5 services). I would like to create a column that gives me the last activity among all the services. For example

User          Last activity Service 1    Last activity Service 2  Last activity service x  Global last activity

User A        13/07/2020                 09/07/2020                  10/07/2020                  13/07/2020

User B         05/03/2020                10/04/2020                  20/05/2020                   20/05/2020

Is there a function that allows to do that ?

Thanks a lot ! 

Laura

[camargos88]

Hi @Anonymous ,

You can use Power Query to handle it more dynamically:

let _user = [User] in

List.Max(Table.Transpose(Table.RemoveColumns(Table.SelectRows(#"Changed Type", each [User] = _user), "User"))[Column1])

Just replace the bold part with your last step name.

[BA_Pete · Accepted solution]

Hi @Anonymous ,

If you wanted to push this work away from the data model, then you would use the List.Max() function in Power Query.

This gives me the following output:

Pete

[amitchandak]

@Anonymous , try with Activity Date

lastnonblank(Table[date],blank())
or
lastnonblankvalue(Table[date],max(Table[date]))