Forum Discussion

T_EA's avatar
T_EA
New Member
1 year ago
Solved

Help with Conditional formatting DAX

Hi All,  I hope I have the correct section of the forum, I have a DAX formula see below:   CF = VAR _today = TODAY() RETURN SWITCH( TRUE(), SELECTEDVALUE(Data[Expiry_Date]) <_today, "#FEB99C", SE...
Need Help
  • sanalytics's avatar
    sanalytics
    1 year ago

    T_EA 
    Can you ISBLANK function for identifying the blank.. Your modifed DAX code should be below

    CF =
VAR _today = TODAY()
VAR _expiryDate = SELECTEDVALUE(Data[Expiry_Date])
RETURN
    SWITCH(
        TRUE(),
        ISBLANK(_expiryDate), BLANK(),
        _expiryDate < _today, "#FEB99C",
        _expiryDate < _today + 30, "#FFED93",
        "#CDFA93"
    )

    check if it is working or not.. If it is not working.. then suggesting to provide some dummy data and desired result to try from out end..

     

    Hope it will help.

     

    Regards,

    sanalytics

sanalytics's avatar
sanalytics
Super User
1 year ago

T_EA 
Can you ISBLANK function for identifying the blank.. Your modifed DAX code should be below

CF =
VAR _today = TODAY()
VAR _expiryDate = SELECTEDVALUE(Data[Expiry_Date])
RETURN
    SWITCH(
        TRUE(),
        ISBLANK(_expiryDate), BLANK(),
        _expiryDate < _today, "#FEB99C",
        _expiryDate < _today + 30, "#FFED93",
        "#CDFA93"
    )

check if it is working or not.. If it is not working.. then suggesting to provide some dummy data and desired result to try from out end..

 

Hope it will help.

 

Regards,

sanalytics