Forum Discussion

hoppalong's avatar
hoppalong
New Member
2 years ago
Solved

References previous value based on user ID

I have the following sample data which has been pulled from application logs.  The login/logout events have a corresponding UserID & Username. When the application disconnects the user it only provi...
Need Help
  • Omid_Motamedise's avatar
    Omid_Motamedise
    2 years ago

    use this code

     

    = Table.Group(Source, {"Username"}, {{"Count", each Table.FillDown(_,{"AD_User"})}})
Omid_Motamedise's avatar
Omid_Motamedise
Icon for Super User rankSuper User
2 years ago

use this code

 

= Table.Group(Source, {"Username"}, {{"Count", each Table.FillDown(_,{"AD_User"})}})