IF Custom Column Formula > 1.5

[android1]

Hi,

I'm looking to replace all values in Actual Hours with the values in Scheduled Hours only if the value in Actual is > 1.5 times the size of the Scheduled value. Trying this> if[Actual Hours]*1.5>[Scheduled Hours]then[Actual Hours]=[Scheduled Hours] but getting token error at the end.

android1

[Anonymous]

I think you need the else 

if[Actual Hours]*1.5>[Scheduled Hours]then[Actual Hours]=[Scheduled Hours] else [Actual Hours]

HTH

Raven

[Anonymous]

Here is a resource that is free with a WEALTH of information - It is an Power Bi class on edx.org

https://courses.edx.org/courses/course-v1:Microsoft+DAT207x+1T2016/info

It has helped me with Power BI

Raven

[android1]

Hi,

Thanks for this. I'm getting False as my answers. Could it ba a formatting issue? My columns are in Decimal Number Format.

android1

[Eric_Zhang]

---

@android1 wrote:

Hi,

Thanks for this. I'm getting False as my answers. Could it ba a formatting issue? My columns are in Decimal Number Format.

android1

---

@android1
Are you talking about adding a column in the query editor?  You got a "False" because the expression [Actual Hours]=[Scheduled Hours] returns "False". Can you try below expression?

if[Actual Hours]*1.5>[Scheduled Hours] then [Scheduled Hours] else [Actual Hours]

[android1 · Accepted solution]

That's perfect Eric. That is exactly what I needed. Thank you.