Power Query table transformation-Mode

[Syndicate_Admin]

Hi,

I was wondering is there any way if we can get the highlighted row as result using power query? in Power BI. So basically its getting Maximum number of Count to be displayed for that specific login User . As table shows, "12345" worked on June 4th for the given Areas out of which maximum he worked was in "Area21" is there any way to display just those two record. Not sure if MODE function will be helpful i tried but it didnt worked.

[Syndicate_Admin]

I tried the given formula using Custom Column but after applying it brings me this result when i expand the table.

[ronrsnfld]

It is not a formula for a custom column. You need to add it in the advanced editor and make the appropriate changes in the previous step references as well as in any subsequent steps that might be in your m code

[ronrsnfld]

Table.SelectRows(#"Previous Step", each [Count] = List.Max(#"Previous Step"[Count]))