Forum Discussion
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 supprimées1"{1}[Numero client]) then Table.FillDown(#"Colonnes supprimées1",{"Nom client", "Prenom client"}) else null
the trouble is that the if statement is not recognized
the left column is my reference et the right the result of the filldown
do you know where i am wrong ?
thanks
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"
6 Replies
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...
