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

Anonymous's avatar
Anonymous
Not applicable
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