Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |