Sameperiodlastyear filter

[Anonymous]

Hi experts 

How would you integrate the same period last year function into the following DAX..

CALCULATE( [Net Sales BM PY] , FILTER( ALL(Profitability[DIM_POSTING_DATE_SK]), CONTAINS( VALUES('DateFilter'[DIM_DATE_SK]),'DateFilter'[DIM_DATE_SK], Profitability[DIM_POSTING_DATE_SK] ) ) ))

[v-lili6-msft · Accepted solution]

hi,@Route11 

    You can use SAMEPERIODLASTYEAR Function to add a calculate measure like this:

Measure 2 = CALCULATE([Measure],SAMEPERIODLASTYEAR(Table2[Date]))

Result:

Best Regards,

Lin

[MFelix]

Hi @Anonymous,

This information is very limited to give you an answer please see this post regarding How to Get Your Question Answered Quickly:

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490 (courtesy of @Greg_Deckler).

Can you provide addtional information on what is the expected result and calculations your need to make.

Regards.

MFelix

[Anonymous]

MFliex - thi si what i came up with

CALCULATE(
        CALCULATE(
        [Net Sales BM]
        ,
        FILTER( ALL(Profitability[DIM_POSTING_DATE_SK]),
            CONTAINS( VALUES('DateFilter'[DIM_DATE_SK]),'DateFilter'[DIM_DATE_SK], Profitability[DIM_POSTING_DATE_SK] ) )
         )
        ,
       SAMEPERIODLASTYEAR(DateFilter[Full Date])

 )