Tying values to a unique identifier

[Js112233]

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

[Sean · Accepted 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!

[Sean · Accepted 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!

[Js112233]

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?

[Sean · Accepted solution]

@Js112233

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]

This is great! Thank you for taking the time!

[Js112233]

Hey! Thank you! This is so incredibly easy I feel sheepish. Thought about it too hard I guess. Thank you!