IFs excel

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/

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/ 🙂