Forum Discussion

GeekAlfPro's avatar
GeekAlfPro
Helper V
6 years ago
Solved

filldown with condition

Hello,   i've a table that i want to filldown, with a condition, based on another column. it doesn't work here is my code   = if (#"Colonnes supprimées1"{+1}[Numero client] = #"Colonnes suppri...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    6 years ago
    let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjS0sDQ3NFXSUXLJT8kHUsGOQY4eQNrAQt/QQN/IwMBYKVYHWR0U4RG0NDA0tyRLMBYA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [#"Numero client" = _t, #"Nom client" = _t, #"Prenom client" = _t, #"Date naissance" = _t]),
    cols=Table.ColumnNames(Source),
    tab=Table.ReplaceValue(Source,"",null,Replacer.ReplaceValue, cols),
   #"Grouped Rows" = Table.Group(tab, {"Numero client"}, {{"fill", each Table.FillDown(_,cols)}}),
    #"Expanded fill" = Table.ExpandTableColumn(#"Grouped Rows", "fill", {"Nom client", "Prenom client", "Date naissance"}, {"Nom client", "Prenom client", "Date naissance"})
in
    #"Expanded fill"
GeekAlfPro's avatar
GeekAlfPro
Helper V
6 years ago

Hi Rocco,

 

thanks for your response.

i tried your suggest, but i've the following message : 

Expression.Error: We cannot convert a value of type Function to type List.
Details:
Value=[Function]
Type=[Type]

i'm pretty new to M and it's not easy for me...

i tried to adapt your code, but without success...

Anonymous's avatar
Anonymous
Not applicable
6 years ago

copy and paste you code here ...

 

paste also the data (dummy version is ok)  you need to transform and the expected result.

 

Paste these as copiable table, please!