Populating Fields

[HenryJS]

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.

[Anonymous · Accepted solution]

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

[amitchandak]

@HenryJS 

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