Forum Discussion

kristi_in_heels's avatar
kristi_in_heels
Helper II
1 year ago
Solved

Switch Statement Not Working

Hello,   I have a switch statement which I am using to apply a conditional formatting in a matrix table where the returned value of the statement is 1.   I have the same switch statement replicat...
Need Help
  • kristi_in_heels's avatar
    kristi_in_heels
    1 year ago

    It seems Power BI needed an update, and then my original statement worked again.

     

    Thank you for the time taken to review.

pankajnamekar25's avatar
pankajnamekar25
Super User
1 year ago

Hello kristi_in_heels 

 

try this

TG EXE Budget Before Today ALL =
SWITCH (
TRUE (),
MAX('All Projects'[ProjectPhaseDescription])="FS" && NOT ISBLANK(MAX('All Projects'[EXE - Budget])) && MAX('All Projects'[EXE - Budget])<TODAY(), 1,
MAX('All Projects'[ProjectPhaseDescription])="PFS" && NOT ISBLANK(MAX('All Projects'[EXE - Budget])) && MAX('All Projects'[EXE - Budget])<TODAY(), 1,
MAX('All Projects'[ProjectPhaseDescription])="Not Started" && NOT ISBLANK(MAX('All Projects'[EXE - Budget])) && MAX('All Projects'[EXE - Budget])<TODAY(), 1,
MAX('All Projects'[ProjectPhaseDescription])="CON" && NOT ISBLANK(MAX('All Projects'[EXE - Budget])) && MAX('All Projects'[EXE - Budget])<TODAY(), 1,
0
)

 

 

Thanks,
 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

kristi_in_heels's avatar
kristi_in_heels
Helper II
1 year ago

Thank you for your reply.

 

Unfortunately the suggestion does not work either.

 

I did wonder if blank cells would be causing the issue, but I updated the data with dummy information to ensure there are no blank cells in the column and this still didn't work.