From the course: Power BI Data Methods (2019)

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Filling up or down columns

Filling up or down columns

From the course: Power BI Data Methods (2019)

Start my 1-month free trial

Filling up or down columns

“

- [Female Speaker] Returning to the US Census Power BI file, and the GEOID to county web query, we put the state name in a separate column, by leveraging a conditional formula. The area name, shows the state name, followed by the counties within it. We scroll down the list, we see the state name is null, until we get to the state of Alaska. What we want to see in this table, is the county name with the state of Alabama in the field next to it. In order to do this, we are going to leverage the Fill Down functionality. An important thing to note about using Fill Up, or Fill Down, is that: in order for the fields to be filled, they need need to have null values in these fields, it won't work with other values, such as "blank". We select the state name, we right click, go to the Fill menu, and select Down. So now we see: Autauga County, Alabama, scroll down, until we get to Haines Borough, Alaska, for example. The last…

Contents