Divide IF value is over a certain amount

Hi elliswoods 

 

= Table.TransformColumns(Your_Source,{{"Your_Column", 
      each if _< 100 or _ = null or _ = "" then _ else _/52.143, type number}})

Stéphane

It's hard to answer without knowing your data and previous steps

Stéphane

Hi elliswoods ,

There's no direct DIVIDEIF function in Power Query, but you can easily achieve this using a conditional column or a simple custom column with an if statement. Here's a quick workaround:

 

In Power Query, add a Custom Column with this formula:

= Table.TransformColumns(
    YourPreviousStep,
    {{"Amount", each if _ > 100 then _ / 52.143 else _}}
)

 

Replace YourColumnName with your actual column name. This will divide the value by 52.143 only if it's over 100, and leave it unchanged otherwise. You can then remove or replace the original column as needed.

Hi elliswoods 

Could you please confirm if your query have been resolved the solution provided by rohit1991 & slorin ? If they have, kindly mark the helpful response and accept it as the solution. This will assist other community members in resolving similar issues more efficiently. If not , kindly share the detailed information regarding the issue.

Thank you

Hi elliswoods 

We have not received a response from you regarding the query and were following up to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you for your understanding and participation.