Making a DAX for 5+ situation

[pete1234]

Hello,

I'm very new to Power BI and Power Query so please bare with me.

I have a column in Power Query from a Sharepoint list. It is called Response Time, and it is the amount of days between the initial contact date of a ticketing system to the response date. I would like to make another column called 5+ Response Time which is just the same as Response Time except when a ticket takes 5 or more days it is generalised as 5+.

How can I make this new column with the new condition? I have copied an example using IF statements in Excel.

[dufoq3 · Accepted solution]

Hi @pete1234, you can us if statement in Power Query as well:

Put this code into Custom Column

if [Response Time] > 5 then "5+" else Text.From([Response Time])

[pete1234]

That's great thanks!

[dufoq3]

You're welcome 😉