Forum Discussion

siddrow's avatar
siddrow
Icon for Helper III rankHelper III
2 years ago

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...
Need Help
siddrow's avatar
siddrow
Icon for Helper III rankHelper III
2 years ago

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. 

Samarth_18's avatar
Samarth_18
Icon for Community Champion rankCommunity Champion
2 years ago

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.