Help on Dax formula - LEFT and Find

[Highlander75]

Hi

I am a dax novice,so would appreciate help on the following:

I am trying to do a LEFT formula that returns a number of characters based on where "-" is located less two spaces.

I got this to work =Left([snName],find("-",[sName],1,0)) which returns for example "2034 -"

but somehow I cannot get the -2 part to work and return "2034", something like =Left([sName,find("-",[sName],1,0)-2)

Any ideas?

 

[scottsen]

Your -2 should work just lovely. How does it not...? (assuming you don't have any weird rows with something like "-tricky")