GIve the date when a certain type of product sales first time exceeds a value

[Qianru221]

Hi all,

Here is the problem description.

I have a column of product names A,B,C,D....

I have entries of product sales revenue from each day. (colums of product names, date of sales, sales revenue value)

I would like to have another column to show when e.g. accumulated product A sales reaches 1M. (The date it becomes a so-called mature product in the market.) 

How I should formulate the DAX in a calculated field /  a customized column?

Thanks in advance.