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 [ExampleColum...
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

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

tomshaw83's avatar
tomshaw83
Helper I
4 years ago

Thank you