Forum Discussion
undefined
Create a calculated column in Job Table as "Status Colour Code" where Job Status = "SUCCESS" should be 1, "FAILED" should be 2, "CANCELLED should be 3"
You may need to write the table as 'Job Table' rather than Job Table.
Status Colour Code =
SWITCH (
TRUE () ,
Job Table[Job Status] = "SUCCESS" , 1 ,
Job Table[Job Status] = "FAILED" , 2 ,
Job Table[Job Status] = "CANCELLED" , 3 )
Anonymous Hope this is what you're after 🙂
Thank for your reply.
But it did not work and I am facing an error
You may need to write the table as 'Job Table' rather than Job Table.