cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
admin11
Memorable Member
Memorable Member

How to add one more condition to my expression to display correct currency sign ?

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

1 ACCEPTED SOLUTION
HotChilli
Super User
Super User

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

View solution in original post

3 REPLIES 3
HotChilli
Super User
Super User

just create a new post - someone else can respond if I'm not around. Good luck

HotChilli
Super User
Super User

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

@HotChilli 

 

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

Helpful resources

Announcements
May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

Power BI Dev Camp Session 22 with aka link 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!