Hi, All,
The formulas of month in my application is as below.
Month(Makedate(2000,Num#(period,'0'))) as Month
And my YTD & MTD formulas is set up like this. However it only works for YTD formulas. It always shows 0 in MTD.
Sum({<[Calendar Year]={$(=Maxstring([Calendar Year]))}>}[Net Sales $])
Sum({<[Calendar Year]={$(=Maxstring([Calendar Year]))},Month={$(=MaxString(Month))}>}[Net Sales $])
Do you have any idea that if my MTD formulas is not working? Thanks a lot.