Setting the max date with filter

[Michael_Hart]

Hi all,

I currently have [Spend] data that I'm wanting to present in a simple table: 

Vendor	Selected Year Spend - 2020	Previous Year Spend - 2019
A	1000	1250
B	400	500
C	800	300

How can I create a filter pane that when a user selects 2020 for example all the [Spend] data from 2019 is still available so I can display the previous years result with set analysis.

Much appreciated,

Michael

[Lisa_P · Accepted solution]

Dimension: Vendor

Measure 1: Sum({$<Year={$(=Max(Year))}>}Spend)

Measure 2: Sum({$<Year={$(=Max(Year)-1)}>}Spend)

[Michael_Hart]

Thank you Lisa!

If you have a moment could you explain how the selection works?

Thank you again 🙂

[Lisa_P]

The expressions Max(Year) and Max(Year)-1 are based on the years available/selected, so will dynamically change based on selections. When you want to evaluate the contents of an expression in set analysis you need to put it in a $( ) - Dollar sign expansion.