if i understand this, you want to return date ?
something like this?
Try this calculation:
IF RANK(ABS(([Total Cashflow]/2) - [Running Sum]),'asc')=1 THEN 'True' ELSE 'False' END
where Total Cashflow is: WINDOW_SUM(SUM([Cashflow]))
and hide "False" value.
attached is sample workbook.
HalfLife.twbx 25.4 KB
I think I'm getting close with your help, but there are still some hurdles.
Below is the visualization which is working properly.
However, when I want to go further,
For example, when I want to put the Half-Life Date into another sheet, it won't work. It will return to the earlier date in the whole digital stream?
Any ideas, thoughts?
This a cash flow for single customer, and I need to visualize a table for all the customers' half-life date
Customer, Cashflow Total, Half-Life Date
A $12,000 Jun 1, 2017
B $93,939,000 Jun 2, 2023
C ... ....
Your approach is close, but I still can not get what I want.