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..
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.
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.
