Forum Discussion

MeghnaZutshi's avatar
MeghnaZutshi
Frequent Visitor
3 years ago
Solved

Calculations on dates

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...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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. 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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.