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 :-
Go to 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")
View solution in original post
Thank you very much , it work fine.
Click here to read more about the October 2021 Release!
Explore the latest tools,training sessions,technical expertise, networking and more.
Mark your calendars and join us for our next Power BI Dev Camp!