PowerPiviotUser
New Member
- Joined
- Nov 7, 2013
- Messages
- 1
I am trying to use a find function in conjunction with a mid function. I need a dynamic lookup return a set of numbers before a dash.
ie 22220-29393. I have been usind a =find(Text, "-") and then it returns the value in which i need. I then need to subtract 5 in order to get to the start of the numbers before the hyphen in a mid fuction. for example in excel it would go like this. =mid(text, (find funtions returned number)-5, 5).
IS there a way to do this in power pivot?
ie 22220-29393. I have been usind a =find(Text, "-") and then it returns the value in which i need. I then need to subtract 5 in order to get to the start of the numbers before the hyphen in a mid fuction. for example in excel it would go like this. =mid(text, (find funtions returned number)-5, 5).
IS there a way to do this in power pivot?
