Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Good morning,
I change my wish to try to find a solution.
In my data, each task_id is associated with a user_name but it is not repeated over the entire column for the same task_id.
How to repeat in another column the user_name associated with a task_id?
Thank you very much.
https://drive.google.com/file/d/1j-P7F-Prw_5y-3QmV8WzE8GdApm1X5NX/view?usp=drive_link
Hi,
you can potentially do this by using the group by option:
1. Select Task_Id as the group
2. Add a username column under aggregation and select Max as the operation of the username colum
3. Add a second aggegation as All Rows
Click okay and expand the all rows column - you should have a new username column (i called it username1) with a completed list.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Hello @DOLEARY85
Thank you very much for your help.
The file I made available is a small file. My real file weighs several GB and the data is on Google big query.
The manipulation you gave me seems to take a long time.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.