Max Date sales by each month

[Rajkumar]

Hi All,

I want to show Sales by max date for each Month.

If my Max date is 15-06-2019. Then I want to show each month sales by this Day .

For  Ex:

Jan  Start Date should  be  01-01-2019  and end date is 15-01-2019

Feb Start Date should  be  01-02-2019  and end date is 15-02-2019

....

Jun Start Date should  be  01-06-2019  and end date is 15-06-2019

Please help  to acheive

[dplr-rn]

create a day column from your date fields in your master calendar

and use an expression something like below

Sum({<Day={"<=$(=day(max(OrderDate)))"}>}Sales)