Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
What are the use cases where I should use MTD Current Month vs Current Month?
Looking at my data for the current month, MTD Current Month and Current Month return the same value. I'm guessing you would likely use Current Month in an expression to do something like budget vs actual to see if you're on track, but I'm not sure.
Reference - [Creating Calendar Measures].
Kind Regards,
Vinny
Hi Vinay ,
Please try below:
Sum({<Date={'>= $(=monthstart(max(Date))) <= $ (=max(Date))'}>}Sales)
Thanks,
Arvind Patil