Forum Discussion
Switch(SelectedValue Help
Hello - I am trying to write a what I think is a simple dax statement however I always end up with an error. I looked at a blog which provides the same type of logic however I cannot get mine to work...
SWITCH( SELECTEDVALUE( SAMPLE_TABLE[PROJECT_HEALTH] ), "Red", "Red", "Green", "Green", BLANK(), "Complete", "" )
SWITCH(
SELECTEDVALUE( SAMPLE_TABLE[PROJECT_HEALTH] ),
"Red", "Red",
"Green", "Green",
BLANK(), "Complete",
""
)Thank you so much. Something so easy and I seem to still struggle.