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
Kr1s's avatar
Kr1s
Frequent Visitor
6 years ago

Hi Pragati11,

 

I saw that but it shows only 1 filter whereas i need 4. Also I need the calculation to read what the product is as we have over 200 so I can't hard code it all into the filter.

 

Thanks,

 

Kristian

  • 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