topic Re: Gap in data, Offset in DAX Commands and Tips

Gap in data, Offset

Anonymous — Sun, 28 Jun 2020 15:12:05 GMT

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.

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

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

Many thanks.

Chris

Re: Gap in data, Offset

Anonymous — Sun, 28 Jun 2020 15:49:55 GMT

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)

Re: Gap in data, Offset

Anonymous — Sun, 28 Jun 2020 18:55:20 GMT

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

Cheers again.

Chris