Help with DAX function LEFT and a dynamic number of characters
I have a column named BinMax which format is text. I'd like to create a calculated column extracting all but the last two chracters of this string. Say, for BinMax="212", I'd like to get "2" as a return. For "1212", I'd like to get "12". I tried: LEFT( [BinMax] LEN([BinMax] - 2) ) but got error: When I try LEN([BinMax] - 1) it works. What seemed so simple has already taken me hours trying to solve it. What am I missing here?
