cancel
Showing results for
Did you mean:
Helper III

## Total sum last year regardles of filters on page

Hi all,

I have a report page with a Matrix table and a Month slicer.

 Customer Sales this year Sales previous year Total sales previous year A 100 120 700 B 40 50 500 C 90 120 1000

The measures [sales this year] and [Sales previous year] are dependent on the month slicer but I want the [Total Sales Previous year] measure to always show the cumulative sales of the entire previous year.

Can you help me to get the formula for [Total Sales Previous Year]

1 ACCEPTED SOLUTION
Helper V

Hi @BobKoenen .

You can use;

[Total Sales Previous Year]=CALCULATE(SUM(table[column]),SAMPLEPERIODLASTYEAR(table[date])).

Regards,

Sanket Bhagwat.

If this post helps,then please mark it as 'Accept as Solution' so that other members could find it quickly.

2 REPLIES 2
Helper V

Hi @BobKoenen .

You can use;

[Total Sales Previous Year]=CALCULATE(SUM(table[column]),SAMPLEPERIODLASTYEAR(table[date])).

Regards,

Sanket Bhagwat.

If this post helps,then please mark it as 'Accept as Solution' so that other members could find it quickly.

Resolver III

Hi @BobKoenen ,

Try using this measure:
Total Sales= CALCULATE(CALCULATE(SUM(Sales),ALL(Dates)),Previousyear(Dates))

Thanks.

Announcements

#### 2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.