Calculate table with Multiple entry for a date

Hi hiba_aziz 

Please try this:

First of all, create a new same table:

Then create a measure to calculate the sum of the cost of the table (2) separately:

SumCost = 
VAR _currentDate1 = MAX('Table (2)'[Date])
VAR _currentID1 = SELECTEDVALUE('Table (2)'[ID])
RETURN CALCULATE(
        SUM('Table (2)'[cost]),
        FILTER(
            ALLSELECTED('Table (2)'),
            'Table (2)'[ID]=_currentID1
            &&
            'Table (2)'[Date]=_currentDate1
            )
        )

Then create a measure to return the target date:

TestDate = 
VAR _currentDate = MAX('Table'[Date])
VAR _currentID = SELECTEDVALUE('Table'[ID])
VAR _CurrentSum = CALCULATE(
                    SUM('Table'[cost]),
                    FILTER(
                        ALLSELECTED('Table'),
                        'Table'[Date]=_currentDate
                        &&
                        'Table'[ID]=_currentID
                        )
                    )
RETURN CALCULATE(
        MIN('Table (2)'[Date]),
        FILTER(
            ALLSELECTED('Table (2)'),
            [SumCost]>_CurrentSum
            &&
            'Table (2)'[Date]>_currentDate
            &&
            'Table (2)'[ID]=_currentID
            )
        )

The result is as follow:

Best Regards,

Zhengdong Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.