Forum Discussion

Kr1s's avatar
Kr1s
Frequent Visitor
6 years ago

SAMEPERIODLASTYEAR with filters

Hi,   I have a dataset consisting of all sales from 2016 to present day. There are multiple entries per date broken down by payer, customer, product group and product.   Whenever I use SAMEPERIOD...
Need Help
Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
6 years ago

Hi Kr1s ,

 

Is it possible for you to share sample data or .pbix file?

 

Thanks,

Pragati

Kr1s's avatar
Kr1s
Frequent Visitor
6 years ago

Hi Pragati11 

 

Unfortunately I can't due to the sensitivity of the data.

 

Regards,

 

Kristian

  • Pragati11's avatar
    Pragati11
    Icon for Super User rankSuper User
    6 years ago

    Hi Kr1s ,

     

    In the following link I see a way to use SAMEPERIODLASTYEAR dax function with multiple filters. 

    https://community.powerbi.com/t5/Desktop/DAX-SAMEPERIODLASTYEAR-Filter/td-p/92084

     

    In the above link you see a dax calculation using 2 filters with && operator:

    Measure =
    CALCULATE (
        DISTINCTCOUNT ( Sales[DocumentNumber] );
        FILTER ( ALL ( Sales ); Sales[Field1] = "1" && Sales[Field2] = VALUE ( 1 ) );
        SAMEPERIODLASTYEAR ( Dates[Date] )
    )

     You can try something similar to add more filters here.

     

    If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

     

    Thanks,

    Pragati