This year v last year

[kevbrown]

I'm looking to compare data from this year to last year which i currently do using -

Count(Distinct{<[Financial Year]={'2015'}>}[Issue ID])

and

Count(Distinct{<[Financial Year]={'2016'}>}[Issue ID])

However, how can i look at a rolling 13 week period for last year and this year. I have date and week in my data so I'm assuming it's not difficult

Thanks

[MK_QSL]

This Year

Count(Distinct{<[Financial Year]={'$(=Year(Today()))'}>}[Issue ID])

Last Year

Count(Distinct{<[Financial Year]={'$(=Year(Today())-1)'}>}[Issue ID])

For rolling 13 period.. use below

Calculating rolling n-period totals, averages or other aggregations

[Anonymous]

Hi,

Perhaps something like this:

This Year

Count(Distinct{<[Financial Year]={$(=max(Year))}>} [Issue ID])

Last Year

Count(Distinct{<[Financial Year]={$(=max(Year-1))}>} [Issue ID])