Forum Discussion

Sajid02's avatar
Sajid02
Helper I
2 years ago

M-Query for Date RAG Status

Hi Techies,  i'm looking to add some custom columns to highlight Green, Amber, Red from a Date column in Power BI.   So basically, my date column is called "LastFilledStatus"   Today & Today...
Need Help
Sajid02's avatar
Sajid02
Helper I
2 years ago

Hi, 

Just want to highlight that , 09/02 /2024 is coming in Red and 08/02/2024 is in Green . Ideally it should not .

I have tried using this in my case, after the code when i am going in conditional formatting , this measure column is taking as first value only. 

Tried creating a column , it is showing only Green vaue , nothing more.

 

Please let me know what to do ?

Thanks 

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Sajid02 ,
Thank you for your reply, as you describe it, my understanding is that you are trying to create a new column to display the colors. If my understanding is correct, can you please provide sample data or pbix file and also please show your desired end result in screenshot or excel so that we can help you better.

Best regards,

Albert He

  • Sajid02's avatar
    Sajid02
    Helper I
    2 years ago

    Hi Anonymous 
    I have put certain conditions & accordingly I need Rag Status column which i can apply in conditional formatting tab.

     





    Thanks