Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
I tried the given formula using Custom Column but after applying it brings me this result when i expand the table.
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
Table.SelectRows(#"Previous Step", each [Count] = List.Max(#"Previous Step"[Count]))