Forum Discussion
Post ProdigySHow numeric values based on the latest date
I am creating a sales report and need to display numeric values in my matrix based on the latest weeks figures,now I can't use a basic filter as the old weeks have a last week of 52 but the current year the week will be different
my table example
sales
year weeknum units income
2021 1 5 500
2021 2 11 1100
2021 3 16 1600
.................
2021 52 197 19700
2022 1 4 400
2022 2 11 1100
2022 3 15 1500
display
2021 2022
income 19700 1500
units 197 15
2 Replies
- Greg_Deckler
Community Champion
akhaliq7 Try:
Units Measure = VAR __Year = MAX('Table'[year]) VAR __Week = MAXX(FILTER('Table',[year]=__Year),[weeknum]) RETURN MAXX(FILTER('Table',[year] = __Year && [weeknum] = __Week),[units])
