Fill down

[Anonymous]

Hi All,

I have a raw data that's being updated every month. What I need (don't know if it's possible or not) is to fill down the "Country" column, based on the above order.

The country's are always in this order:

Albania

Algeria

Argentina

etc.

When the new raw data is uploaded it doesn't include the country column, it only includes other columns (columns with values)

What I need is to fill down the new rows I've uploaded (new Raw data) with the Country names but in the same order.

At the moment if I use fill Down, it will select the last country name (Zimbabwe) and fill that name to all of the new rows, but I need it to remember the order of Country column and fill first row with Albania, second row with Algeria and so on.

Is this possible?

[v-zhangti · Accepted solution]

Hi, @Anonymous 

You can try the following methods. First you need to add an index column, starting from 1.

Create a new table and fill out the names of the countries you need to add in order.

Create a new custom column.

if [Column1] = "" then
let
a= List.Count(#"Added Index"[Column1]),b=List.Count( List.Select(#"Added Index"[Column1], each _ = "")),c=Number.Mod([Index]-(a-b)-1, 3)
in
#"Table (2)"{c}[Column1]
else [Column1]

Is this what you expect the output to be?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.