DAX calculation to find Date when total becomes a certain value (2x, 3x, etc.)

[hyggins]

Good afternoon!

I have three columns: Date, Running Total and Growth. I am wanting to create another column ("Date Doubled") that indicates when, on a later date, the Running Total doubled.  See example data below. On 1/1 the Running Total was 621. On 1/4 the Running Total was 1,247. This is the earliest date when Running Total was equal to or more than the 1/1 value of 621. Thank you!

Date	Running Total	Growth	Date Doubled
1/1/2020	621		1/4/2020
1/2/2020	772	151	1/6/2020
1/3/2020	1026	254	1/7/2020
1/4/2020	1247	221	1/8/2020
1/5/2020	1525	278	1/10/2020
1/6/2020	2000	475	1/11/2020
1/7/2020	2366	366
1/8/2020	2651	285
1/9/2020	2808	157
1/10/2020	3929	1121
1/11/2020	4638	709

[camargos88 · Accepted solution]

Hi @hyggins ,

Try this code :

Column =

VAR _date = 'Table'[Date]

VAR _value = 'Table'[Running Total]

RETURN CALCULATE(MIN('Table'[Date]); FILTER(ALL('Table'); 'Table'[Running Total] >= _value * 2))

Ricardo

[az38]

Hi @hyggins 

Date Doubled = 
CALCULATE(
MIN('Table'[Date]), 
FILTER(ALL('Table'),'Table'[Running Total] >= 2* SELECTEDVALUE('Table'[Running Total]) )
)