last six or last seven prices per item per customer

BORUCH

Well-known Member
Joined
Mar 1, 2016
Messages
528
Office Version
  1. 365
Platform
  1. Windows
[FONT=&quot]Hi,[/FONT]
[FONT=&quot]I’m looking for a power pivot formula that would do the following[/FONT]
[FONT=&quot]I have my invoice history detail table, in power pivot that looks like this.[/FONT]
[FONT=&quot]Customer number,Customer name ,Invoice date ,Invoice number ,Item number ,Item Description ,Price ,Amount Etc…[/FONT]
[FONT=&quot]What i would like to do is to be able to list an item number and a Customer Number, and have the pivot table list me the last six prices that, that particular customer paid for that particular item[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]P.S. Maybe even to have a slicer that i can select last six ,last seven etc…[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]Thanks, any help is greatly appreciated[/FONT]
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
I wrote a very similar formula today for one of the students in my online power BI training course. Basically you want a rankx to find the Last 6 prices. This is tricky because getting the last 6 is harder than say 6 largest. If you post a power pivot workbook with some realistic data, I will help you more.
 
Upvote 0
I wrote a very similar formula today for one of the students in my online power BI training course. Basically you want a rankx to find the Last 6 prices. This is tricky because getting the last 6 is harder than say 6 largest. If you post a power pivot workbook with some realistic data, I will help you more.

hi
how would i post an attachments my settings are set that i cant



  • "You may not post attachments"
 
Upvote 0
Hi

i'm not familiar with drop box and i'm not sure about posting a public link
if you can somehow send me a formula based on my question i would appreciate it

thanks
 
Upvote 0

Forum statistics

Threads
1,213,568
Messages
6,114,348
Members
448,570
Latest member
rik81h

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top