Forum Discussion
izzu
2 years agoFrequent Visitor
Trying to Create conditional Column or formatting based on performance
Trying to Create conditional Column or formatting based on Ticket handel (performance) in a Metrix Tabel Condition should be if - Ticket Assigned No - is More , Breach Ticket No - is Less , Ticket O...
Anonymous
1 year agoNot applicable
To be honest, I don't understand your real needs, izzu .
I can only see that you want to create a conditional column named Performance.
The Performance column is based on the countings of the previous columns.
I would like to ask you to explain in detail what constitutes Fair, Poor, and Good in the Performance column.
For conditinal calculating, we often use IF() or SWITCH() to return results.
IF function (DAX) - DAX | Microsoft Learn
SWITCH function (DAX) - DAX | Microsoft Learn
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.