Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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.
Solved! Go to 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/
Proud to be a Super User!
@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/ 🙂
Proud to be a Super User!
@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/ 🙂
Proud to be a Super User!
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/
Proud to be a Super User!
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.