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.

v-prasare's avatar
v-prasare
Community Support
1 year ago

Hi kristi_in_heels,

Can you try below query once and let me know if this helps:

 

TG EXE Budget Before Today COLUMN =

VAR Phase = TRIM('All Projects'[ProjectPhaseDescription])

VAR BudgetDate = 'All Projects'[EXE - Budget]

RETURN

SWITCH(

    TRUE(),

    Phase IN {"FS", "PFS", "CON", "Not Started"} &&

    NOT ISBLANK(BudgetDate) &&

    BudgetDate < TODAY(), 1,

    0

)

 

 

 

 

 

 

Thanks,

Prashanth Are

MS Fabric community support

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query