I've got a table with various Item Id's and for each item there are multiple Orders. So there's a row for each order containing an Order Created date. I'm trying to create a measure that will allow me to dynamically view the first order created date based on a date range slicer I have.
Here is some sample data. Based on the date range currently selected I'd like the highlighted values to be the dates that return for those respective items.
If I would then change the date slicer to 1/1/2020 - the measure would return these highlighted dates:
This would be my expected value if I had the measure included in the table:
If I wasn't concerned with the Item Id's my calculation would be something like this: Calculate(Min(Table[Order Created]), Allselected(Table)).
But I'm not sure how to take the Item's in to account so my value is unique for each item. Ideally the measure would return the min value for each row that exists for that item and not just the first one.
Thanks in advance.