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],L...
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))
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?