Forum Discussion

setis's avatar
setis
Icon for Post Partisan rankPost Partisan
3 years ago

Using ALL for last year

Hi experts, I'm calculating the weight of the number of cases on each day of the month like this:   I have 2 questions. 1.- How can I calculate on a measure on the same table the [Weight da...
Need Help
setis's avatar
setis
Icon for Post Partisan rankPost Partisan
3 years ago

Greg_Deckler It looks correct, but I´m getting 100% on all rows. 

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

setis The scintillating joy of CALCULATE. What is your Cases measure? The formula? Could maybe try this:

Measure =
  VAR __Date = MAX('Date'[Date])
  VAR __LYDate = DATE(YEAR(__Date)-1,MONTH(__Date),DAY(__Date))
RETURN
  CALCULATE([Weight day on month],ALL('Date'), 'Date'[Date] = __LYDate)