Gap in data, Offset

[Anonymous]

Hi

Not sure if the subject title is right, I dont know how else to describe this.  I have UK locations, a column which has a Region and a column that has a County.  As you can see from the picture below; taken from within Power BI Query Editorr, there are gaps, the name of the region does not filter down for each row or correspondining row for that region.  

So this is the view I have in Query Editor.  There is a'null' value for each County following Region first heading, e.g. Nothern-England, line 2 has a 'null' value. 

ModelViewQuery

What I want the data to look like this; I tweaked the table in excel but can we do this in PowerBI maybe?

Excel Version

Once the rows are populated then I will use this to build a lookup table.

Many thanks.

Chris

[harshnathani · Accepted solution]

Hi @Anonymous ,

You cna use the Fill Down option in Power Query.

See this video how to do it.

https://www.youtube.com/watch?v=vQIDJVkFW8o

Regards,

Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[Anonymous]

Hi 

Thats great, funny enough I did come across this option aftwards.  Power BI is amazing stuff.

Cheers again.

Chris