create a custom column that returns a value if number is below specific cap value

Question

i'm trying to create a column that checks if the achievement is less than 0.5 , it should round the number to 0.5 otherwise, it should return the number as is. for example , if achievement is 0.2 or 0.3 , the column should return 0.5 and if achievment is 1.2 it will return 1.2. i tried to create the custom column with below code but it didn't work.

if ([achievement])<0.5 then 0.5 else ([achievement])

vijay_a_verma · Accepted Answer

Looks like your numbers are in text format. You can do this
if Number.From([achievement])&lt;0.5 then 0.5 else Number.From([achievement])
A shorter construction would be following
List.Max({Number.From([achievement]), 0.5})

Forum Discussion

create a custom column that returns a value if number is below specific cap value

1 Reply

Related content

Create Measure to Return Highest Value

Return "Specific value" from table 1, if not found, return value from table 2

Specific matrix

Creating custom columns keeps returning a structured Table column

Using two conditions to return a specific value