Forum Discussion
heathernicole
Continued Contributor
Continued ContributorSWITCH statement in DAX using a "between this value and this value" as a filter?
VERY new to DAX - I think my issue is I haven't nailed down how to ask the right question yet - which hinders research for an answer: Trying to create an IF (or a Switch) statement If "this v...
I have same senario the below Column measure is not working. Kindly please help me on this
Phase_Highlight = SWITCH(TRUE(),
NOT(ISBLANK(New_Scope[Requirement Start Date])) && New_Scope[Requirement End Date]= BLANK(),"#d74e26",
NOT(ISBLANK(New_Scope[Analysis Start Date])) && New_Scope[Analysis End Date]=BLANK(),"#d74e26",
NOT(ISBLANK(New_Scope[Design Start Date])) && New_Scope[Design End Date]=BLANK(),"#d74e26",
NOT(ISBLANK(New_Scope[Development Start Date])) && New_Scope[Development End Date]=BLANK(),"#d74e26",
NOT(ISBLANK(New_Scope[Business UAT Start Date])) && New_Scope[Business UAT End Date]=BLANK(),"#d74e26",
NOT(ISBLANK(New_Scope[Estimated Go Live])) && New_Scope[Actual Go Live]=BLANK(),"#d74e26"
)
WulffJoergen
Helper I
Helper II know it is a while ago you posted this, but a good advice is to post in separate post - I get most replies this way.