Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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?
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.
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.
@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])
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
113 | |
105 | |
95 | |
58 |
User | Count |
---|---|
175 | |
147 | |
134 | |
105 | |
82 |