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

     

Kedar_Pande's avatar
Kedar_Pande
Super User
9 months ago

  

RAG Status =
SWITCH(
TRUE(),
ISBLANK('Table'[Due Date]), "No Due Date",
'Table'[Due Date] < TODAY(), "Red",
'Table'[Due Date] <= TODAY() + 30, "Amber",
"Green"
)

 

The ISBLANK check must come first since blank dates will also satisfy the other conditions.

 
If this answer helped, please click Kudos or mark as Solution.
-Kedar
LinkedIn: https://www.linkedin.com/in/kedar-pande

gauravg3