Add Days/Time based on Condition Column

[Jon8930]

Hi,

I am fairly new to power query and I am having an issue with a sort of if function, in which i need a new column to return a date/time plus a few days/hours based of a condition in another column. Im not really sure how to set up the syntax and the column?

[BA_Pete]

Hi @Jon8930 ,

If you can provide a simple example of what your source data looks like and what your expected output looks like for each variable then this shouldn't be too difficult to sort for you.

Pete

[Jon8930]

For example,

I would like a new column called SLA, to do the following:

(I am aware this an excel formula buts the best way can explain it)

each if [Issue Type] = "Hardware" then [CreatedDate] + I want it to add either a few hours or a few days.

The new columm i want to return the modified date/time dependant on the condition.

So if hardare add four hours etc.

Hope this makes sense.

[BA_Pete · Accepted solution]

Yup, no problem.

Create a new custom column in Power Query with this structure:

if [Issue Type] = "Hardware" then [Created] + #duration(0, 4, 0, 0)  //four hours
else if [Issue Type] = "Software" then [Created] + #duration(4, 0, 0, 0)  //four days
else if [Issue Type] = "Remote Access" then [Created] + #duration(0, 0, 4, 0)  //four minutes
... etc.
else  // your escape value e.g. null, [Created]

Pete