Forum Discussion
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...
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.
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 😕
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