Forum Discussion

tomshaw83's avatar
tomshaw83
Helper I
4 years ago
Solved

Help with basic IF problem

Hi, I am trying to write a simple IF statement in Power Query, I want to return a value every time an odd value appears in a rank column. I am writing 

 

if [rank] = Number.IsOdd then [ExampleColumn] else [ExampleColumn2]

 

The Number.IsOdd section is picking up, can anyone help point me in the right direction?


Thanks


Tom

 

 

Need Help
  • BA_Pete's avatar
    BA_Pete
    4 years ago

    Hi tomshaw83 ,

     

    You need to use the Number.IsOdd function correctly:

    if Number.IsOdd([rank]) then ... else ...

     

     

     

    Pete

2 Replies

  • BA_Pete's avatar
    BA_Pete
    Super User
    4 years ago

    Hi tomshaw83 ,

     

    You need to use the Number.IsOdd function correctly:

    if Number.IsOdd([rank]) then ... else ...

     

     

     

    Pete