Forum Discussion

al1ceDav1n's avatar
al1ceDav1n
Regular Visitor
3 years ago

SWITCH STATEMENT NOT WORKING

Hi   Could some one help with the below SWITCH statement? Thanks in advance   Volume = SWITCH( 'RTY_UY'[EFFECT DATE] and 'TYU_JP' [REMAINING_FLAG] = "N", 0 ('RTY_UY'[EFFECT DATE] and 'TYU_JP' [RE...
mlsx4's avatar
mlsx4
Icon for Memorable Member rankMemorable Member
3 years ago

Hi al1ceDav1n 

 

It is difficult to know what you're trying to do, but I think you shouldn't include effect date here

Volume = SWITCH( 'TYU_JP' [REMAINING_FLAG],
"N", 0,
"Y",COUNT([INT_ID], 
COUNT([INT_ID]))