Forum Discussion

setis's avatar
setis
Post 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
Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

setis Maybe:

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

Measure 2 =
  VAR __Date = MAX('Date'[Date])
  VAR __LYDate = DATE(YEAR(__Date)-1,MONTH(__Date),DAY(__Date)+1)
RETURN
  CALCULATE([Weight day on month],'Date'[Date] = __LYDate)
  • setis's avatar
    setis
    Post Partisan
    3 years ago

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

    • Greg_Deckler's avatar
      Greg_Deckler
      Community 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)
      • setis's avatar
        setis
        Post Partisan
        3 years ago

        Unfortunately, same result.

        My cases measure is:

        Cases = CALCULATE(COUNTROWS(Cases) ,Cases[statuscodename] <> "Cancelled")