How to implement MTD upto to till month from starting of the year?

[lakhansajwan]

Plzz tell me how to implement the MTD For the whole year upto any date of the selected month?

i.e if i select a date of September then the  MTD till that date of sep with that date of previous month from the starting of the year.

[Gysbert_Wassenaar · Accepted solution]

Create a Day field in the script from your Date field:

Load ...your fields...,

Day(MyDate) as Day

From ...somewhere...;

You can then use that Day field in set analysis expressions:

sum({<Day={$(=max(Day)},MyDate=>} Amount)

[israrkhan]

Hi,

Please find the Attcahment . Different ways for achieving YTD and MTD are mentioned in this . Hope this will help you .

Regards

Khan