Power Query M equivalent of excel conditional IFS formula for a conditional column

[indrajeet_rajput]

So, I have a date&time column in my raw data which I extract daily (the date&time refers to the audit date&time), along with a Feedback Status column(which can have only these three values Accepted/Rejected or Pending) We don't have any date/time for when the feedback was Accepted or Rejected....

I need to create a column for Ontime or Late Feedback acknowledgement where the condition is => if it has been over 48 hours from the Audit date&time and the Feedback Status is "Accepted"or"Rejected" it should return "Late Acknowledgement"; Or if it has been less than 48 hrs from the Audit date&time and the Feedback Status is "Accepted" or "Rejected" it should return "Ontime Acknowledgement"

I have used this formula below in excel:
IFS(AND (NOW()-A2<2, OR (B2="Accepted", B2="Rejected")), "On Time Acknowledgement", AND (NOW()-A2>2,OR(B2="Accepted", B2="Rejected")), "Late Acknowledgement", B2="Pending", "Pending")

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: reddit
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.