previous year end of the month

[sudhakar111]

Hi ,

We have a date slicer which is based on a calendar table. For Example if i enter date 09/01/2017 and till date which is 09/18/2017,I

need to show the measures for previous year end of the month,so it should be sum(measure) for 09/01/2016 and 09/30/2016. It should show for the entire month and not date to date comparison.

Best Regards,

[v-chuncz-msft · Accepted solution]

@sudhakar111,

You may refer to the following DAX.

Measure =
VAR d =
    MAX ( 'Calendar'[Date] )
RETURN
    CALCULATE (
        SUM ( Table1[Column1] ),
        Table1[Date]
            >= DATE ( YEAR ( d ) - 1, MONTH ( d ), 1 )
            && Table1[Date]
                < DATE ( YEAR ( d ) - 1, MONTH ( d ) + 1, 1 )
    )

[sudhakar111]

Thanks a lot. I tried the formula with minor changes and it worked perfectly.