Based on Slicer Selection - Need to get sum of historical data

[Mavericks334]

Hi,

How do i create a measure, where in the slicer if i select any given year, based on that year, it needs to go to the data table and calculate the sum of all the previous years values.

Regards,
Renato.

 

[Jacob Barnett]

See post #9 in your other thread, the first half of that measure filters the sales measure by using FILTER() on the calendar table.
Jacob