Forum Discussion

pmazara's avatar
pmazara
Frequent Visitor
6 years ago
Solved

Conditional Replace Value across table (multiple rows/columns) for values greater than 1

Seeking help in figuring out a query that will replace all values greater than 1 with 1   see attached screenshot
Need Help
Show and Tell
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    Hi,

     

    Please try to add custom columns in Query Editor:

    Hope this helps.

     

    Best Regards,

    Giotto Zhi

v-gizhi-msft's avatar
v-gizhi-msft
Community Support
6 years ago

Hi,

 

Please try to add custom columns in Query Editor:

Hope this helps.

 

Best Regards,

Giotto Zhi