DAX Lookup for equal or greater values

[btfergie]

Is there a way do get DAX functionality similar to Excel Lookup wehre you dont need an exact match but rather less than or greater approximate match?

[btfergie]

A little more information...

I am trying to figure out which PO date items would have been used in disposition based on first in first out.  For example the 1504 items on 5/14/2020 would have come form the 3/30/2020 PO for the first 1000 and 504 for the 4/3/2020 PO. 

I was going to try and lookup the appoximate the running total of dispositions on the running total of PO items.  If I

My running total of disposition isnt quite working however.

[v-xicai]

Hi @btfergie ,

I am trying to figure out which PO date items would have been used in disposition based on first in first out. 

From your description, you may need to get value 1000 matched to row of date 3/30/2020 and value 504 matched to row of date 4/3/2020, right?  If so, you may clarify the logical about the Lookup and the result values.

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@btfergie , what is the context for that , this type statement can give min or max across table

Try as new column

City Name = maxx(FILTER(geography,geography[City Id]=Sales[City Id]),geography[City]) // new column in sales

within same table

last date = maxx(filter(Table, [Employee] =earlier([Employee]) && [Modified date] <earlier([Modified date])),[Modified date])
last status = maxx(filter(Table, [Employee] =earlier([Employee]) && [Modified date] =earlier([last date])),[Field 1])