Variations with specific dates

Question

Hi everyone&nbsp;I'm stuck with a calculation, and i've been looking at the forums but i haven't found anything similar yet.&nbsp;The database is as follows. I&nbsp;have 3 columns Year, id_Month and Number, and the data is monthly, from January(1) to December(12) for each year that goes from 2006 to 2016&nbsp;i'm&nbsp;trying to calculate&nbsp;the increases or decreases for a chosen month, something like YTD formula, but the catch here is that because of the nature of this data, the total of a year isn't the sum of all the months but instead the data of December alone&nbsp;So for example, if i want to calculate the variation of February 2016, the formula should go something like this:&nbsp;(Sum of February 2016) minus (December 2015)&nbsp;and so on for every February of the remaining&nbsp;years (Sum of February 2015 minus December 2014)&nbsp;&nbsp;So i could&nbsp;have a stacked column chart by year in the X axis showing each february's variation&nbsp;i found YTD and SamePeriodLastYear but i couldn't&nbsp;find a way, as i said, i don't need to sum every month for a given year to calculate the total of that year.&nbsp;Also the idea is to have a filter in the canvas so i could choose the month i want to evaluate&nbsp;Any ideas? also thx in advance for the help&nbsp;&nbsp;

zubair_muhammad · Accepted Answer

GeraSanz11&nbsp;Try this MEASURE&nbsp;Measure =
SUM ( TableName[Number] )
    - CALCULATE (
        SUM ( TableName[Number] ),
        FILTER (
            ALL ( TableName ),
            TableName[id-Month] = 12
                &amp;&amp; TableName[YEAR]
                    = SELECTEDVALUE ( TableName[YEAR] ) - 1
        )
    )

Forum Discussion

Variations with specific dates

2 Replies

Related content

Variations on December

Variations with specific dates

DAX calcul variations

Enter Specific Date

Specific matrix