last six or last seven prices per item per customer

[BORUCH]

[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]

 

[Matt Allington]

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.

 

[BORUCH]

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"

 

[BORUCH]

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

• "you may not post attachments"

any updates to my question

 

[Matt Allington]

save to dropbox or onedrive and post a link

 

[BORUCH]

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