Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Matching up data in Power BI

I have an ask to build a report where I need to correlate recent activity with past activity based on customer.   Example:  Customer bought a new item in 2020 who also had purchased an item in 2017...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    I appreciate you looking into this.  I don't want to waste any more of your time.

     

    I did a simple solve with Excel.

     

    Thanks!

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks for the quick reply.  The matrix table that I'm using has all proprietary information unfortunately.

 

Here's some more details.

 

I have data from 2017 - 2020.  I need to show someone who bought an item in 2020 that bought in previous years.  So, I was assuming I can build an output table that finds the same customer in all years meeting the qualifications of spending more than $1,000 per item, per year.

 

Hope you can help

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

Hi,

Share a dummy dataset and show the expected result.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

     

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      5 years ago

      Hi,

      Share the link from where i can download your PBI file.

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        I appreciate you looking into this.  I don't want to waste any more of your time.

         

        I did a simple solve with Excel.

         

        Thanks!