Get Delta Per Month and per Year in a Matrix with date hierarchy

[Gregoire]

I want to get the delta with the previews month when the raw hierarchy is a month and get it by year when the hierarchy is year.
I know I can have it by creating a another column but I want to display it in the same column for not confuse the reader.
So, my question is can I do that? And how?

here is what I have now.

But as you can see the delta I have for 2020 is 10'640 but what I expect is 250'798.

My actual delta formula is 

Delta =

IF(

    ISFILTERED('TD_Date'[Date]),

    ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."),

    VAR __PREV_MONTH =

        CALCULATE(

            SUM('TF_Case'[Case]),

            DATEADD('TD_Date'[Date].[Date], -1, MONTH)

        )

    RETURN

        DIVIDE(

            SUM('TF_Case'[Case])

                - __PREV_MONTH,

            1

        )

)

Thanks for your time 🙂

[lbendlin · Accepted solution]

use ISINSCOPE rather than ISFILTERED.

[lbendlin · Accepted solution]

use ISINSCOPE rather than ISFILTERED.

[Gregoire · Accepted solution]

For thus how are looking a what the formula look in the end here is it

Delta =

IF(

    ISINSCOPE('TD_Date'[Date].[Month]),

    VAR __PREV_MONTH =

        CALCULATE(

            SUM('TF_Case'[Case]),

            DATEADD('TD_Date'[Date].[Date], -1, MONTH)

        )

    RETURN

        DIVIDE(

            SUM('TF_Case'[Case])

                - __PREV_MONTH,

            1

        ),

    IF(

        ISINSCOPE('TD_Date'[Date].[Year]),

        VAR __PREV_YEAR =

            CALCULATE(

                SUM('TF_Case'[Case]),

                DATEADD('TD_Date'[Date].[Date], -1, YEAR)

            )

        RETURN

            DIVIDE(

                SUM('TF_Case'[Case])

                    - __PREV_YEAR,

                1

            ),

            VALUE(0)

        )

)