Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Fill down

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 ...
Need Help
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    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.

v-zhangti's avatar
v-zhangti
Community Support
4 years ago

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.