Forum Discussion
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 please advise what is the issue?
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
2 Replies
Hi,
Share the link from where i can download your PBI file.
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
