PowerQuery. Excel - Not sure how to enter data

Question

Good evening all,

I used to be active on the old platform but just getting to grip with the new one.

I received an Excel sheet today and wanted to do the following Conditional formatting:
If due date is equal = 0 OVERDUE
If due date is 0 - 3 = STILL TIME
If due date is bigger than 3 =OK
How do I enter these conditions in PowerQuery.

Thanks for your help.

Answer 1

Hi Techunsavy,

For your concern, this is usually done as a Conditional Column or a Custom Column in Power Query. If your “Due Date” column already contains number of days, you can try this:

• In Power Query Editor, select Add Column > choose Custom Column.
• Use this formula:

if [Due Date] = 0 then "OVERDUE"
else if [Due Date] > 0 and [Due Date] <= 3 then "STILL TIME"
else if [Due Date] > 3 then "OK"
else "OVERDUE"

You can give it a try and let me know if it works. If not, for the best possible assistance, please share a screenshot of your current data structure so I can provide the most appropriate guidance for your case. If you have any other questions, please feel free to reach out again in the comments on this post. I'm happy to assist you further

Thank you for your understanding and cooperation. I'm looking forward to your reply.

---

If the answer is helpful, please click "Yes" and kindly upvote it.

Note: Please follow the steps in the documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Thanks

How do I enter AND in PowerQuery?
else if [Due Date] > 0 and [Due Date] <= 3 then "STILL TIME"

NB: I cannot find the Reply button