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 replicated 4 times with a different column being used to measure against. 3 of the 4 are working perfectly, but the last is not. Is there something I have missed in the statement? All the columns are formatted the same, and all relationships are the same. WORKING STATEMENT:TG FS Budget Before Today ALL =SWITCH (TRUE (),MAX('All Projects'[ProjectPhaseDescription])="PFS"&& max('All Projects'[FS - Budget])<Today(),1,max('All Projects'[ProjectPhaseDescription])="Not Started"&& max('All Projects'[FS - Budget])<Today(),1,max('All Projects'[ProjectPhaseDescription])="CON"&& max('All Projects'[FS - Budget])<Today(),1,0) NOT WORKING STATEMENT:TG EXE Budget Before Today ALL =SWITCH (TRUE (),MAX('All Projects'[ProjectPhaseDescription])="FS"&& max('All Projects'[EXE - Budget])<Today(),1,MAX('All Projects'[ProjectPhaseDescription])="PFS"&& max('All Projects'[EXE - Budget])<Today(),1,max('All Projects'[ProjectPhaseDescription])="Not Started"&& max('All Projects'[EXE - Budget])<Today(),1,max('All Projects'[ProjectPhaseDescription])="CON"&& max('All Projects'[EXE - Budget])<Today(),1,0)

It seems Power BI needed an update, and then my original statement worked again. Thank you for the time taken to review.

Switch Statement Not Working | Microsoft Fabric Community