Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Solved! Go to Solution.
use this code
= Table.Group(Source, {"Username"}, {{"Count", each Table.FillDown(_,{"AD_User"})}})
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
use this code
= Table.Group(Source, {"Username"}, {{"Count", each Table.FillDown(_,{"AD_User"})}})