Forum Discussion

Jason2500's avatar
Jason2500
Helper I
5 years ago
Solved

If condition in Power Query?

Hi    I have a column called workdays as below       I want to create a new column based on the workdays by using the below if condition,   However, I am getting an error. Can you...
  • amitchandak's avatar
    5 years ago

    Jason2500 , Put a else at end and check

     

     else " unknow"

     

    Also there is not need ot two condition.

    The second condition can be [Working day] < 60

    Because you will not reach here if it is <= 30