DAX power Pivot or Calculated Column return previous row nonnumeric value

Hi,

I'm trying to get nonnumeric value from the previous row, I've use MAXX this for a numeric vlaue
I've included workbook showing what I'd like to get back using lookupvalue.
Meassure ;

Please Login or Register  to view this content.

I'm stuck as to how to get eg "A" , [[Tunits] is sum(Tablle1[Units]) ,

So far I've got , but can't use max to bring back a non number;

Please Login or Register  to view this content.

I tried uisng a measure ; MAX(Table1 [Item]) , but this gives only one answer in the totals;

Any suggestions, (helpful)

Richard

Hi,
thanks, not quite sure if this is what you meant, but it seems to work,
First I just used the 'Lookup column so ;

Please Login or Register  to view this content.

but as I really wanted t avoid a calculated column tried using Lookupvalue inside concatenatex

In One:=

Please Login or Register  to view this content.

Which also works. Now to get the same result but without an index and just a non consecutive date column to work off , Hmmm.


Richard

Thanks, I hadn't actually got around to having a go, it wasn't until the first response that I found you can use Lookupvalue in a measure, I'd only used it in columns, another way to solve this in power bi might be to use the new OFFSET function, but I've not really had a go of using it yet and can't imagine it works in power pivot.

Richard.

Just to add my reason for wanting this is that, and you are probably aware, but if you use the item
with a grow measure (Sale - Previous) / Previous, it also filters by the item only show a result where there are consecutive item.
but if you put in the previous item, it all makes sense.

I've uploaded examples of both.

Richard