Forum Discussion

akhaliq7's avatar
akhaliq7
Icon for Post Prodigy rankPost Prodigy
4 years ago
Solved

SHow 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 y...
Need Help
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi akhaliq7 

    please  use

    Units Last Week =

    CALCULATE ( SUM ( Sales[Units] ), Sales[weeknum] = MAX ( Sales[weeknum] ) )

    same for income. 

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
4 years ago

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])