Matching up data in Power BI

[Anonymous]

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, 18 or 19.  I have other variables too but if I can solve this basic one, I can figure out the rest.

Sounds like a pivot table almost but with all the variables, it's not.  Besides, I'm creating in BI to be refreshable.  

Thanks!

[themistoklis]

Hello @Anonymous 

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

[Anonymous]

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]

Hi,

Share a dummy dataset and show the expected result.

[Anonymous]

[Ashish_Mathur]

Hi,

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

[Anonymous · Accepted solution]

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!