Forum Discussion

HenryJS's avatar
HenryJS
Post Prodigy
6 years ago
Solved

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.        
Data Protection
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    6 years ago

    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's avatar
amitchandak
Super User
6 years ago

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