Forum Discussion
Solved
Conditional Coulmn
Hi 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 sh...
Try reversing the order of your conditions.
ValtteriN
Community Champion
Community ChampionHi,
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!
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!
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. 🙂