Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

If statement with wildcards

Hello,    I have about 15 years of data broken out into 4 categorys based on season FA, WI, SP, SU. I am attempting to label each label as Fall, Winter, Spring, Summer.  The data looks like 2020/FA...
DAX
DAX Calculation
DAX Language
colacan's avatar
colacan
Icon for Resolver II rankResolver II
4 years ago

Anonymous Hi, you can try below CALCUALTE COLUMN;

 

Season =
SWITCH(True,
SEARCH("SP",TABLE[YearSeason],,BLANK())>0,"SPRING",
SEARCH("SU",TABLE[YearSeason],,BLANK())>0,"SUMMER",
SEARCH("FA",TABLE[YearSeason],,BLANK())>0,"FALL",
SEARCH("WI",TABLE[YearSeason],,BLANK())>0,"WINTER", BLANK()
)
 
Thanks
 
Please mark as soluntion if this helped.