Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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....
Solved! Go to 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 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
thanks Greg!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.