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:
You can use Groupby in PQ to get that figure pretty easily:
Using this formula it will only return the first date of my calender table. If I want to see the first sales date of my table this formula will not work. I need calculate the min date of the calender table when sales values in not blank. Can anyone help me on this.