Max year Max month

[Awais-Ashraf]

Hello ! i am facing this issue when i write this expression Sum({<[Year]={$(=Max([Year]))},[Month]={$(=Max(Month))}>}[Sales Amount]) i get "0" as output but when i write it as Sum({<[Year]={$(=Max([Year]))},[Month]={$(=MaxString(Month))}>}[Sales Amount]) i get the desired output but when i want to have the output for Last month and Sum({<[Year]={$(=Max([Year]))},[Month]={$(=MaxString(Month)-1)}>}[Sales Amount]) i dont see any output. as we cannot subtract int from String. Please Help..

[andoryuu · Accepted solution]

In your dataload put Num() around your month field to ensure it is read in as an integer instead of a string. Then you can go back to using Max() and subtracting from it.