Forum Discussion
IFs excel
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.
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/ 🙂
3 Replies
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/ 🙂Thanks very much Tom, it worked brilliantly. Really appreciate your response, I was struggling with it.
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/
