Forum Discussion

pstanek's avatar
pstanek
Post Patron
10 years ago

MAX MIN

I have table with columns   Office -Product-  Stock Value. I need to create  Product - MIN Stock - Office with min stock - Max stock - Office with max stock   I try to avoid to order new product...
Need Help
Show and Tell
pstanek's avatar
pstanek
Post Patron
10 years ago

Is LASTNONBLANK supported in direct query?

Anonymous's avatar
Anonymous
Not applicable
10 years ago

pstanek I don't think so. If your offices are numbered you could use MAX(StockTable[Office]) instead of LASTNONBLANK. If Office is a text field maybe something like CONCATENATE(StockTable[Office], "") I am not sure what to do about that. You need some way to get a single row value and LASTNONBLANK/FIRSTNONBLANK is the only way I know of for that.