Forum Discussion
Switch traffic light colour
Hi I am trying to switch the colours based off mulitple criteria but I am stuck. I created my traffic lights. Traffic Lights = UNICHAR(11044) I have created this measure to calcualt...
Sorry, could you please add more info? It's not making sense to me. Are you saying created a custom column in Power Query for Due Date Days from Today? If so, I can't use this column in my measure either.
siddrow I am suggesting not to create any measure and go ahead with creating columns for both Due Date Days from Today and Traffic Lights Colour. You don't need to create it in power query you can create it directly after the data load.