Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
hoppalong
New Member

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 provides the Usernum and not their actual username making it difficult to identify who has been repeatedly disconnected. 

 

I've joined my login/logout/disconnected events into one table and would like to somehow replace those null values within the AD_User by referencing the previous usernum id.

 

 

 

hoppalong_1-1729065341908.png

 

1 ACCEPTED SOLUTION
Omid_Motamedise
Super User
Super User

use this code

 

= Table.Group(Source, {"Username"}, {{"Count", each Table.FillDown(_,{"AD_User"})}})
If my answer helped solve your issue, please consider marking it as the accepted solution. It helps others in the community find answers faster—and keeps the community growing stronger!
You can also check out my YouTube channel for tutorials, tips, and real-world solutions in Power Query with the following link
https://youtube.com/@omidbi?si=96Bo-ZsSwOx0Z36h

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Hi @hoppalong ,

I tested Omid_Motamedise's reply and it works well!
If Omid_Motamedise's reply helps you, please remember to accept the reply as solution to help the other members find it more quickly. Thank you!

Best Regards,
Dino Tao

Omid_Motamedise
Super User
Super User

use this code

 

= Table.Group(Source, {"Username"}, {{"Count", each Table.FillDown(_,{"AD_User"})}})
If my answer helped solve your issue, please consider marking it as the accepted solution. It helps others in the community find answers faster—and keeps the community growing stronger!
You can also check out my YouTube channel for tutorials, tips, and real-world solutions in Power Query with the following link
https://youtube.com/@omidbi?si=96Bo-ZsSwOx0Z36h

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.