cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GeekAlfPro
Advocate I
Advocate I

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

 

2020-07-24 13_58_53-Données Coralie Dédommagement - Éditeur Power Query.png

 

do you know where i am wrong ?

 

thanks

1 ACCEPTED SOLUTION

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"

View solution in original post

6 REPLIES 6
Rocco_sprmnt21
Super User II
Super User II

it is not clear your starting point, but I guess you could try to fill.down after group by "numero client":

 

somethink like this (I didn't tested it)

Table.Group (#"Colonnes supprimées1", "Numero client", { each Table.FillDown(_,{"Nom client", "Prenom client"})})

 

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...

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!

 

 

here are the dummy data

in red the wanted filldown 

when "Numero Client" change, i don't want a filldown anymore

maybe the trouble come from some of my blue values are blank

 

Numero clientNom clientPrenom clientDate naissance
1189715DodoSARAH08/10/2003
1189715DodoSARAH08/10/2003
1189715DodoSARAH08/10/2003
1190179  
1190179   
1190179   

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"

View solution in original post

Hi Rocco,

 

thanks a lot, it works fine !

thanks again

 

have a good day

Helpful resources

Announcements
User Groups Public Preview

Join us for our User Group Public Preview!

Power BI User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors