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

     

PhilipTreacy's avatar
PhilipTreacy
Super User
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