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.

smather's avatar
smather
Helper III
5 years ago

PhilipTreacy 

 

The file is giant and connected to our server, unfort I can't share it. Apologies about the screenshots, lemme try again. I can confirm that the margin is down as % and there's no spaces in any of the phase names (or, there isn't at the source).  

 

I'll give an example of my data (and ideally what it should spit out). Each line is a item, be it labour, kit or licences. And at the visual level, it aggreates them together based off the phase. 

 

Here's some screenshots (I made my own margin box, just in case the one pulling through was playing silly):  

 

 

I just don't understand. All those are for the same project, each line is just another labour day. 

 

Sorry about the new thread, the forum would not let me post a reply to you 😞

PhilipTreacy's avatar
PhilipTreacy
Super User
5 years ago

Thx smather 

Well without the actual data to hand I think I've suggested everything I'd check.

If % Margin is 30% as shown in your images then the only thing I can think of is that there are some non-prining characters or spaces in the Phase col, but you said that's not the case.

Can you please humour me and double check with this new column

 = Text.Length([Phase])

Regards

Phil