Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Dynamic last december measure

Hi everyone,

 

I'm working on a measure to calculate the last December value so my measure is : 

 

Total  = CALCULATE(SUM('QPTOTAL'[Revenue]))
 Last December = CALCULATE(CALCULATE([Total],LASTDATE('Calendar'[Year/Month])),PARALLELPERIOD('Calendar'[Year/Month],-1,YEAR))
 
Do you have any idea to ameliorate this measure to a dynamic Last December, so I can have as result Last December 2018 Last December 2017 ..... When I select the year as a filter. 
 
Best regards.
Thank you 
 
 
Dynamic Date Period
Measures
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous 
    Please try this measure and check if it works for you

    Measure = 
VAR _selectedYear = SELECTEDVALUE('Table'[Date].[Year])-1
RETURN CALCULATE(SUM('Table'[Sales]),FILTER(ALL('Table'),YEAR('Table'[Date])=_selectedYear && MONTH('Table'[Date])=12))

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous 
    Please try this measure and check if it works for you

    Measure = 
VAR _selectedYear = SELECTEDVALUE('Table'[Date].[Year])-1
RETURN CALCULATE(SUM('Table'[Sales]),FILTER(ALL('Table'),YEAR('Table'[Date])=_selectedYear && MONTH('Table'[Date])=12))
    • ed144's avatar
      ed144
      Regular Visitor
      6 years ago

      Thanks Anonymous . I am facing the exact same issue. Your code works, but it sums the previous december value for my whole dataset. How can I make the measure account for the filters I apply in my report?