Forum Discussion
DAX Formula to Return First Date Based on Other column
Hi All, I'm trying to create a column that calculates the original due date for a set of items that have due dates that can be extended over and over again. For example, in this table, I want the...
Anonymous
try
Original Due Date = CALCULATE ( MIN ( 'Table'[Due Date] ), ALLEXCEPT ( 'Table', 'Table'[Item] ) )
Dear rdcooper,
Is this you expected?
The DAX Expression i have used to get this as follows.
Measure_OrderDate = CALCULATE(MIN(PBI_Data[OrderDate]), ALLEXCEPT(PBI_Data,PBI_Data[Item]))
Regards,
Pradeep
You can use Groupby in PQ to get that figure pretty easily:
Dear rdcooper,
Is this you expected?
The DAX Expression i have used to get this as follows.
Measure_OrderDate = CALCULATE(MIN(PBI_Data[OrderDate]), ALLEXCEPT(PBI_Data,PBI_Data[Item]))
Regards,
Pradeep
And what if I have multiple types of binders (e.g. red, green) defined in an aditioanl column, and now we want to return all binders with first date (there might be 2). How to write function to retain both Binder green and binder red record:
ITEM COLOR OrderDate Binder Red 2018-01-10 Binder Green 2018-01-10 Binder Red 2018-02-10 Binder Red 2018-03-10 Binder Red 2018-04-10 Binder Red 2018-05-10