Forum Discussion

margheritamart's avatar
margheritamart
Frequent Visitor
3 years ago
Solved

Table.AddColumn argument not working

Hi!

 

I am trying to create wordcount bands in Power Query editor but I am doing something wrong as I get only <500 or 500 to 2000, i get why but I have not been able to create the different band properly

= Table.AddColumn(#"Changed Type", "Wordcount bands3", each if [#"Project size#(lf)(total)"] < 500 then "< 500" else if [#"Project size#(lf)(total)"] > 500 then "500 to 2000" else if [#"Project size#(lf)(total)"] > 2000 then "2000 to 5000" else if [#"Project size#(lf)(total)"] > 5000 then "5000 to 10000" else if [#"Project size#(lf)(total)"] > 10000 then ">10000" else null)

Can someone help me please?

TGhanks

Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    3 years ago

    Hi margheritamart ,

    Please modify the formula to:

    = Table.AddColumn(#"Changed Type", "Wordcount bands3", each if [#"Project size#(lf)(total)"] < 500 then "< 500" else if [#"Project size#(lf)(total)"] > 500 and [#"Project size#(lf)(total)"]<=2000 then "500 to 2000" else if [#"Project size#(lf)(total)"] > 2000 and [#"Project size#(lf)(total)"]<=5000 then "2000 to 5000" else if [#"Project size#(lf)(total)"] > 5000 and [#"Project size#(lf)(total)"]<=10000 then "5000 to 10000" else if [#"Project size#(lf)(total)"] > 10000 then ">10000" else null)

    By my test it works fine:

    I attach my sample below for your reference.

     

    Best regards,

    Community Support Team_yanjiang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Community Support
    3 years ago

    Hi margheritamart ,

    Please modify the formula to:

    = Table.AddColumn(#"Changed Type", "Wordcount bands3", each if [#"Project size#(lf)(total)"] < 500 then "< 500" else if [#"Project size#(lf)(total)"] > 500 and [#"Project size#(lf)(total)"]<=2000 then "500 to 2000" else if [#"Project size#(lf)(total)"] > 2000 and [#"Project size#(lf)(total)"]<=5000 then "2000 to 5000" else if [#"Project size#(lf)(total)"] > 5000 and [#"Project size#(lf)(total)"]<=10000 then "5000 to 10000" else if [#"Project size#(lf)(total)"] > 10000 then ">10000" else null)

    By my test it works fine:

    I attach my sample below for your reference.

     

    Best regards,

    Community Support Team_yanjiang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.