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
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

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!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!