Return lowest date on set of data
I have 2 dimensions, one is Dates and one is accounts, and I want to return the first date for each different account where an amount occurs and on future line in that account
How do i do this?
they all have the same dates associated with them, but that date ins't necessarily the first date with an amount for each account. And i want the resulting first date to be on every line for every account on each dates, as i need to test against it.
I thought i could do a rank function on the dates, where amount doesn't equal zero, so that gives me the lowest number for each account, which corresponds to a date, but am unable to get that lowest date on every line and not totally sure how to convert the rank back to a date?