Forum Discussion

Akshay_echo1995's avatar
Akshay_echo1995
Regular Visitor
2 years ago

Conditional Formatting not executting completely.

Hi Everyone,   We have 2 columns one with user name and on other we have the login date when they have last logged in, when we are trying to do conditional formatting to check whether they are logi...
Need Help
PijushRoy's avatar
PijushRoy
Community Champion
2 years ago

Hi Akshay_echo1995 

Please try below DAX

 

DRV2 =
IF (
   ( SELECTEDVALUE ( 'DW Celoxis_TimeEntries'[data']][0]]['workItem_data_plannedStart] ) - Today()) <= 7,
    "Green",
    IF (
       ( SELECTEDVALUE ( 'DW Celoxis_TimeEntries'[data']][0]]['workItem_data_plannedStart] ) - Today())<= 14,
        "Amber",
        "Red"
    )
)

 

 


Let me know if that works for you


If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush
Linkedin

Akshay_echo1995's avatar
Akshay_echo1995
Regular Visitor
2 years ago

Aleady tried this but only getting Green , its not getting executed for Amber and Red.