Forum Discussion

gauravg3's avatar
gauravg3
Helper I
9 months ago
Solved

RAG Status for Due Date

Hi All, Pls help advise how to setup RAG status based on due date.   If due date is before today, then Red If due date is between today and 30 days then Amber If due date is after days then Gree...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    9 months ago

    Hi gauravg3 

     

    Download example PBIX file 

     

    RAG Status = 

SWITCH( TRUE(),

ISBLANK([Due Date]), "No due date"),

[Due Date] < TODAY(), "Red",

[Due Date] >= TODAY()  && [Due Date] < TODAY() + 30 , "Amber",

"Green"

)

     

     

    Regards

     

    Phil

     

v-aatheeque's avatar
v-aatheeque
Community Support
8 months ago

Hi gauravg3 

Have you had a chance to look through the responses shared earlier? If anything is still unclear, we’ll be happy to provide additional support.

v-aatheeque's avatar
v-aatheeque
Community Support
8 months ago

Hi gauravg3 

We wanted to follow up to check if you’ve had an opportunity to review the previous responses. If you require further assistance, please don’t hesitate to let us know.