Calculate date of first and last activity taking into account other columns

[Syndicate_Admin]

Nice day

I hope you can help me with this question.

I have the following table:

And I want to calculate for each user, taking into account the machine, the environment and the application, the first time and the last time you used each application. How could I do it?

Thank you very much in advance!!

[amitchandak · Accepted solution]

@Syndicate_Admin , with these columns, Min and max of Fecha should do

or create a new column like

calculate(min(Table[Fecha]), allexcept(Table, [account], [machine],[environment]))

or max

calculate(Max(Table[Fecha]), allexcept(Table, [account], [machine],[environment]))