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