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!

themistoklis's avatar
themistoklis
Icon for Community Champion rankCommunity Champion
5 years ago

Hello Anonymous 

 

Could you send us a sample of the output table you are looking for?

  • 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