Forum Discussion

smather's avatar
smather
Helper III
5 years ago
Solved

M Code Percentage Thresholds

Hi   I created a custom column in the Query Editor:    if [Phase] = "Equipment" and [Margin] < 20 then "Below Threshold" else null   I've also used 0.20/0.19 and 19 to no avail, as it keeps hig...
Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    5 years ago

    Hi, smather 

     

    You can try: if text.trim([Phase]) = "Equipment" and [Margin] < 20 then "Below Threshold" else null

    If it doesn’t solve your problem, please feel free to ask me.

     

    Best Regards

    Janey Guo

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Carmichael's avatar
Carmichael
Advocate III
5 years ago

Can you share a screen shot of the data with the data types visible?

I recreated based on my underrsanding and your formula worked for me.

 

= Table.AddColumn(#"Changed Type", "AND", each if [Phase] = "Equipment" and [Margin] < 0.2 then "Below" else null)

 

Result

 

  • smather's avatar
    smather
    Helper III
    5 years ago

    Can do! See below: 

     

     

    There's no spaces in the phase col - the data source doesn't have any, so unless BI is off doing its own thing (stranger things have happened!), that shouldn't be the issue 😕

    • PhilipTreacy's avatar
      PhilipTreacy
      Super User
      5 years ago

      Hi smather 

      The screenshots are a bit confusing.  Some of it is PQ but doesn't show the custom column, some is a Table viz?

      Can you actually share some real data we can test?  Or share the PBIX?

      Regards

      Phil