I am trying to turn an expression into a dimension .
Details : i am calculating the last purchase date of a product by using the MaxString function , every product has multiple purchase dates and this shows its last .
what im trying to do is to filter and select the last purchase date in order to check which product dates to which year . but i cannot introduce the maxstring function as a calculated dimension .
Note, I think you should make sure your dates are real dates and not strings so you can calculate with them. For example max(purchasedate) instead of maxstring(purchasedate). And calculations on numbers perform better than calculations on strings.
