Calculated Column DAX Help

[MKPBI_2805]

I am stuck with a calculated column creation, can anyone help -- 

Here is my SQL & DAX Codes for a CALCULATED COLUMN.

SQL Code -

CASE WHEN HEADER_TABEL.REGION='AMERICA' AND DETAIL_TABLE.TRANS_CODE='CANCEL' THEN 'CANCELLED' ELSE COALESCE(COALESCE(RIGHT(FINANCE.SUBSCRIPTION_STATUS_M,CHARACTER_LENGTH(FINANCE.SUBSCRIPTION_STATUS_M)-1),RIGHT(FINANCE_T.SUBSCRIPTION_STATUS_M,CHARACTER_LENGTH(FINANCE_T.SUBSCRIPTION_STATUS_M)-1)),'NOT CANCELLED') END AS SUBSCRIP_STATUS

DAX i tried --

SWITCH(TRUE(),
'HEADER_TABEL'[REGION]="AMERICA && MAX('DETAIL_TABLE'[TRANS_CODE])="CANCEL","CANCELLED",
COALESCE(COALESCE(RIGHT('HEADER_TABEL'[SUBSCRIPTION_STATUS_M],LEN('HEADER_TABEL'[SUBSCRIPTION_STATUS_M])-1),
RIGHT('HEADER_TABEL'[SUBSCRIPTION_STATUS_M_T],LEN('HEADER_TABEL'[SUBSCRIPTION_STATUS_M_T])-1)),"NOT CANCELLED"),
BLANK())

[az38 · Accepted solution]

@MKPBI_2805 

I think in your case a simple IF will be more appropriate solution

IF(

'HEADER_TABEL'[REGION]="AMERICA && MAX('DETAIL_TABLE'[TRANS_CODE])="CANCEL", 
"CANCELLED",
COALESCE(
RIGHT('HEADER_TABEL'[SUBSCRIPTION_STATUS_M],LEN('HEADER_TABEL'[SUBSCRIPTION_STATUS_M])-1),
RIGHT('HEADER_TABEL'[SUBSCRIPTION_STATUS_M_T],LEN('HEADER_TABEL'[SUBSCRIPTION_STATUS_M_T])-1),
"NOT CANCELLED"
)

)