DAX to split data than lookups and removes certain data from cell value

K

kfschaefer1

New Member
Joined
Feb 28, 2016
Messages
9
I am looking for the proper DAX syntax to check string value Starts with "*Bonus* or display all data left of the "**" else display the name as is and if so remove it.

If starts with "Bonus" or contains * then strip the data and only display the correct name. See sample data.

ResourseNames
Mary Jo Taylor **HOURLY** $45 / hr
Jon Smith
*BONUS* Tom Kane

I want to strip of everything but the employee name?

Karen
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
You must log in or register to reply here.

Similar threads

T
  • Question Question
Using Excel to create a schedule table from given data table.
Replies
1
Views
867
Herakles
H
D
  • Question Question
VBA - Split Source file-Find oldest date in column. Copy all rows with date to new sheet, Repeat on next oldest date. Also, remove some unwanted data.
Replies
0
Views
1K
DK643
D
B
  • Question Question
VBA transferring cells with defined content from a worsheet to another
Replies
0
Views
543
bbnhn
B
J
  • Question Question
Excel macro for Remove comma's and spaces from a cell and place the data in different cell
Replies
3
Views
1K
JEC
JEC

Forum statistics

Threads
1,224,154
Messages
6,176,731
Members
452,740
Latest member
MrCY

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top