Forum Discussion

pete1234's avatar
pete1234
Frequent Visitor
2 years ago
Solved

Making a DAX for 5+ situation

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.

 

Need Help
  • dufoq3's avatar
    dufoq3
    2 years ago

    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])

     

3 Replies

  • dufoq3's avatar
    dufoq3
    Community Champion
    2 years ago

    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])