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.
Hello!
I have attached a picture showing the scenario I face. I export a .csv sheet that has 4 columns. One has a generic name that is repeated every time a new identifier appears in column 2. Two has a unique ID, the third column has the employee id, and the fourth has the hours worked.
The issue is that the unique identifier only shows in one row therefore only times to the first entry in column three and 4. All other employees and their subsequent hours do not have a unique identifier and can not be joined properly to the other table I desire to join to.
Is there a way to solve this when I edit my query? It will be a monthly report so I am hoping there is a way!
Thank you for any feed back !
Description | ID | Employee | Hours |
Repair_details | 15625.0s | Employee 1 | 0.5 |
Employee 2 | 1 | ||
Employee 3 | 1 | ||
Repair_details | 15768.0t | Employee 5 | 0.5 |
Employee 3 | 0.5 | ||
Employee 2 | 0.5 | ||
Repair_details | 157869.0h | Employee 5 | 1.5 |
Employee 2 | 1 | ||
Employee 1 | 1.5 |
Solved! Go to Solution.
@Js112233 Try this Fill Down feature in the Query Editor
Right-Click each Column that has values missing => Fill => Down
And the result...
Hope this helps!
Haha @Anonymous
From the link in your post today! Thanks!
EDIT: Refresh works too!
I first created a sample Excel file with the data you had posted.
Then I just added 5 additional rows to the sample data as in the picture - saved and closed Excel as is in the Picture below
Then in PBI hit Refresh and this is the updated result!
Good Luck!
@Js112233 Try this Fill Down feature in the Query Editor
Right-Click each Column that has values missing => Fill => Down
And the result...
Hope this helps!
Haha @Anonymous
From the link in your post today! Thanks!
EDIT: Refresh works too!
When you say refresh works too, does that mean in a month from now when I replace the CSV the old ones will fill in correctly and the newly added data (that will have new IDs) will just need to be filled in?
I first created a sample Excel file with the data you had posted.
Then I just added 5 additional rows to the sample data as in the picture - saved and closed Excel as is in the Picture below
Then in PBI hit Refresh and this is the updated result!
Good Luck!
This is great! Thank you for taking the time!
Hey! Thank you! This is so incredibly easy I feel sheepish. Thought about it too hard I guess. Thank you!
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.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |