Calculate year level measure

[AshokkumarM]

Hi,

    My requirement is get to full year total of selected month or each month like below report, Could anyone help in achieving this.

Thanks,

Ashok Kumar M

[Eric_Zhang · Accepted solution]

@AshokkumarM

You may need a calendar table and measures as below.

currentYearSales = CALCULATE(SUM(yourTable[sales]),ALLEXCEPT('calendar','calendar'[Date].[Year]))


lastYearSales = CALCULATE(SUM(yourTable[sales]),FILTER(ALL('calendar'),'calendar'[Date].[Year]=MAX('calendar'[Date].[Year])-1))

See more details in the attached pbix file.