How to use DAX to recode Customer Code TU10004 as USA currency

[admin11]

Hi All

TU10004 , the U stand for USA currency.

U10002 , without U stand for SGD currency.

I try some thing like below , it does not work

If(Mid(AR[Customer/Vendor Code],2,1)  = 'U','USD','SGD') 

Return :- UDS or SGD

My PBI file :-

https://www.dropbox.com/s/3xd8mdw9g3qry9p/PBT_V2021_396%20TI_SI_GL%20SAMPLE.pbix?dl=0

Paul

[amitchandak · Accepted solution]

@admin11 , I tried this column and it is giving the correct value . A new column

USD = If(Mid(AR[Customer/Vendor Code],2,1)  = "U","USD","SGD") 

[admin11]

@amitchandak 

Thank you very much , it work fine.

Paul