Forum Discussion
Solved
transfer a Excel formula into Power BI
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....
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
2 Replies
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 nullthanks Greg!
