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:
Zubair_Muhammad
Community Champion
Community ChampionAnonymous
try
Original Due Date = CALCULATE ( MIN ( 'Table'[Due Date] ), ALLEXCEPT ( 'Table', 'Table'[Item] ) )
Fro88erHelper IV
How to take this measure one step further by calculating when the Due Date = Origional Due Date, (Y/N or T/F)? Where to incert an if statment or a variable?