Calculating changing date

[Asmoday1507]

Hi everyone!

I'd like to calculate the date of sale (stock exit) for the following data, but when trying to use the earlier function, it doesn't quite work out for me.

I would like it to be a calculation column.

[v-cgao-msft · Accepted solution]

Hi @Asmoday1507 ，

Try this Column.

Expected sale date = 
IF (
    'Table'[Stock]
        <> CALCULATE (
            SUM ( 'Table'[Stock] ),
            LASTDATE ( 'Table'[Date] < EARLIER ( 'Table'[Date] ) ),
            ALL ( 'Table'[Stock] )
        ) && 'Table'[Date] <> MIN('Table'[Date]),
    'Table'[Date]
)

The result should be like this.

Also, attached the pbix file as the reference.

Best Regards,

Community Support Team_Gao

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[TheoC]

Hi @Asmoday1507 - you should be able to achieve what you're after using MAXX function.

[sevenhills]

I think your screenshot does not reflect what you need ...

Can you explain in few lines and also check the screenshot image adapt those requirements?