Calculations on dates

[MeghnaZutshi]

How to get MTD sales  for current month and for previous month, same date range? Suppose today is April 15 so i would require sales from

1. 1st to 14th April and

2. 1st to 14th March . 

These should be two seperate calculations

Thanks in advance

[Anonymous · Accepted solution]

Hi @MeghnaZutshi ,

According to your description, we can create two measures.

MTD Sales April =
CALCULATE (
    SUM ( Sales[Sales Amount] ),
    DATESBETWEEN (
        'Date'[Date],
        DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ), 1 ),
        TODAY () - 1
    )
)

MTD Sales March =
CALCULATE (
    SUM ( Sales[Sales Amount] ),
    DATESBETWEEN (
        'Date'[Date],
        DATE ( YEAR ( EOMONTH ( TODAY (), -2 ) ), MONTH ( EOMONTH ( TODAY (), -2 ) ), 1 ),
        EOMONTH ( TODAY (), -2 ) + DAY ( TODAY () ) - 1
    )
)

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.