Forum Discussion
Populating Fields
Hi all,
I have some poorly structured data.
How can I add a Measure or Column so that Christopher Constable has a '1' in every 'ok to pay' cell? Not just the top one.
Hi HenryJS,
In fact, measure and calculated column not suitable for this requirement, they can't directly modify original table record values.
In my opinion, I'd like to suggest you enter to 'query editor' to enable 'fill down' function on your 'ok to pay' field.How to Fill Down Blank or Null Cells in Power Query
Notice: If fill down not working, please double check your record values if any whitespace/specific characters that block fill down feature.
Regards,
Xiaoxin Sheng
2 Replies
Try
new column =1 new column = switch(true(), [firstname]="Christopher" && surname ="Constable", 1, ///other conditions if needed blank() )suggested switch in place if so that other conditions can be added easily
Hi HenryJS,
In fact, measure and calculated column not suitable for this requirement, they can't directly modify original table record values.
In my opinion, I'd like to suggest you enter to 'query editor' to enable 'fill down' function on your 'ok to pay' field.How to Fill Down Blank or Null Cells in Power Query
Notice: If fill down not working, please double check your record values if any whitespace/specific characters that block fill down feature.
Regards,
Xiaoxin Sheng
