Return a list of column values with a filter

[DataDownUnder]

Im sure this is simple and I am overthinking it.

I am adding a sparkline to a revenue visual, I only want to show dyanmically the last 2 periods of revenue in the spark line for the trend.

For the X axis of the Sparkline I need to add a measure which restricts the Periods to only the last 2 periods.

How do I use a measure to show a filtered list of values from a table column?

I can genereate a condition which tells me current period-2,  so I need to show periods in the date table which are >= current period

My <period table> is 

Period

1

2

3

4

5

6

7

8

9

10

11

12

[DataDownUnder · Accepted solution]

Just found that this is not possible as measures can not be used for X axis in the sparkline.  Instead a relative date filter is required on the visual