topic Conditional Coulmn in DAX Commands and Tips

Conditional Coulmn

richpow — Wed, 22 Dec 2021 09:57:12 GMT

I've added a new conditional column for ticket status. It is pulling status from other columns,

So if Complaint is Yes it should display Pending Acknowledgement, then if LOA is Sent it should change to Pending Final Response etc etc.

However, if the first condition is met, it's entering that and not updating.

So for example, Complaint is yes so its displaying Pending Acknowledgement however LOA Status has been updated to Sent but it's not updating the colum to Pending Final Response.

The order should be:

If Complaint Yes - Pending Acknowledgment... but if

LOA status Sent - Pending Final Response... but if

FR Status Sent - Pending Portal Update... but if

Overall Status Complated - Closed

If none of those conditions met - display as Pending Initial Review

It's stuck on the first one and updating everything as Pending Acknowledgement and not checking for the others. any suggestions?

Re: Conditional Coulmn

ValtteriN — Wed, 22 Dec 2021 10:28:19 GMT

Hi,

It seems this question could belong in Power Query section if you want to do it with a conditional column?
If you are you doign it with DAX here is one way to do this:

Dax:

Path = SWITCH(TRUE(),

'Disposition number'[Task ID]="T1"&&'Disposition number'[Project ID]="A"&&'Disposition number'[Parent Task ID]="","T1",

'Disposition number'[Task ID]="T2"&&'Disposition number'[Project ID]="A"&&'Disposition number'[Parent Task ID]="T1","T2","Conditions not met")

Example data:

Logic explained:
So here I created a similar situation where if certain conditions are met my DAX returns set values (T1 and T2) similarly to your "pending statuses". If these conditions are not met the value returned is

"Conditions not met".

I hope you can use this logic to solve your issue and if you do consider accepting this post as a solution and giving a thumbs up!

Re: Conditional Coulmn

richpow — Wed, 22 Dec 2021 10:23:59 GMT

Thank you for your reply, Forgive me, I find it hard to follow that. I will review it and see if I can follow the logic. 🙂

Re: Conditional Coulmn

AlexisOlson — Wed, 22 Dec 2021 19:23:22 GMT

Try reversing the order of your conditions.