transfer a Excel formula into Power BI

[engingee]

Hi everyone,

I tried to transfer a Excel fomular into Power BI, but not exactly know how, could anyone help please?

(A4 in below stands for the colunm number in excel)

My excel fomular is: 

=IF(OR(A4=1,A4<1),"Q1",IF(OR(A4=1.1,A4=1.5,AND(A4>1.1,A4<1.5)),"Q2",IF(OR(A4=1.6,A4=2,AND(A4>1.6,A4<2)),"Q3",IF(A4>2,"Q4"))))

How can I write this fomula in powerBI, I tried add conditional colunm in edit query, but not work....

[Greg_Deckler · Accepted solution]

@engingee I think:

= if [A] = 1 or [A] < 1 then "Q1" else if [A]=1.1 or [A]=1.5 or ([A]>1.1 and [A]<1.5) then "Q2" else if [A]=1.6 or [A]=2 or ([A]>1.6 and [A]<2) then "Q3" else if [A] > 2 then "Q4" else null

[engingee]

thanks Greg!