Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All
Below expression work fine for SOURCE =TS :-
_CURRENCY = If(Mid(AR[Customer/Vendor Code],2,1) = "U","USD","SGD")
The above expression only suitable for SOURCE = TS
May i know how to add one more condition for above expression ?
If SOURCE = TA , then display SGD
If SOURCE = TP , then display MYR
If SOURCE = TI , then display IDR
Hope some one can advise me.
My sample PBI file :-
https://www.dropbox.com/s/ageeb7resqpsysk/PBT_SOLVE%20AR%20CURRENCY.pbix?dl=0
Thank you
Paul
Solved! Go to Solution.
Are you looking for a SWITCH statement?
_CURRENCY =
SWITCH (AR[SOURCE],
"TS", IF (MID(AR[Customer/Vendor Code],2,1) = "U", "USD", "SGD") ,
"TA", "TASGD" ,
"TP", "MYR" ,
"TI", "IDR" ,
"N/a no value"
)
If the logic looks right, please test at your side
just create a new post - someone else can respond if I'm not around. Good luck
Are you looking for a SWITCH statement?
_CURRENCY =
SWITCH (AR[SOURCE],
"TS", IF (MID(AR[Customer/Vendor Code],2,1) = "U", "USD", "SGD") ,
"TA", "TASGD" ,
"TP", "MYR" ,
"TI", "IDR" ,
"N/a no value"
)
If the logic looks right, please test at your side
Thank you very much , now when i select SOURCE = TP , Currency will display MYR.
Thank you for your help.
Can i ask you follow up question , related to recode currency , using this post to ask or should i create new post ?
Paul Yeo
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |