Forum Discussion

engingee's avatar
engingee
Icon for Helper I rankHelper I
4 years ago
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:  ...
Need Help
Tutorial Requests
  • Greg_Deckler's avatar
    Greg_Deckler
    4 years ago

    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's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
4 years ago

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's avatar
engingee
Icon for Helper I rankHelper I
4 years ago

thanks Greg!