IFs excel

[PXJ]

Hi all,

I am trying to achieve the below that I've created in excel in power bi:

Brand1=IF(Products[Brand]="Nissan", Products[Brand]&" "&"("&Products[PC]&")",Products[Brand]

IF(Products[Brand]="Subaru", Products[Brand]&" "&"("&Products[PC]&")",Products[Brand]

IF(Products[Brand]="Toyota", Products[Brand]&" "&"("&Products[PC]&")",Products[Brand]

IF(Products[Brand]="Mazda", Products[Brand]&" "&"("&Products[PC]&")",Products[Brand]

Products

Brand	PC
Nissan	123
Subaru	456
Toyota	789
Mazda	987
Audi	654
BMW	658
Mercedes	321
Nissan	951
Subaru	753
Toyota	852
Mazda	258

Brand1

Nissan (123)

Subaru (456)

Toyota (789)

Mazda (987)

Audi

BMW

Mercedes

Nissan (951)

Subaru (753)

Toyota (852)

Mazda (258)

Thanks for your help.

[tackytechtom · Accepted solution]

Hi @PXJ ,

Here a solution in Power Query:

and here the code:

if [Brand]="Nissan" then [Brand] & " (" & [PC] & ")" else if [Brand]="Subaru" then [Brand] & " (" & [PC] & ")" else if [Brand]="Toyota" then [Brand] & " (" & [PC] & ")" else if [Brand]="Mazda"  then [Brand] & " (" & [PC] & ")" else [Brand]

Let me know if this works 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[tackytechtom · Accepted solution]

@PXJ ,

Here a solution as a calculated column in DAX:

And here the code:

BrandCalculatedColumn = 
SWITCH (
    TRUE,
    [Brand]="Nissan", [Brand] & " (" & [PC] & ")",
    [Brand]="Subaru", [Brand] & " (" & [PC] & ")",
    [Brand]="Toyota", [Brand] & " (" & [PC] & ")",
    [Brand]="Mazda", [Brand] & " (" & [PC] & ")",
    [Brand]
)

Hope either of the solution helps 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/ 🙂

[PXJ]

Thanks very much Tom, it worked brilliantly.  Really appreciate your response, I was struggling with it.

[tackytechtom · Accepted solution]

Hi @PXJ ,

Here a solution in Power Query:

and here the code:

if [Brand]="Nissan" then [Brand] & " (" & [PC] & ")" else if [Brand]="Subaru" then [Brand] & " (" & [PC] & ")" else if [Brand]="Toyota" then [Brand] & " (" & [PC] & ")" else if [Brand]="Mazda"  then [Brand] & " (" & [PC] & ")" else [Brand]

Let me know if this works 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/