Forum Discussion
engingee
Helper I
Helper Itransfer 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: ...
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
Greg_Deckler
Community Champion
Community Championengingee 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
engingeethanks Greg!