Finding the Minimum Date based on existance of a Value

[AJ]

Hello, this should be a straightforward transformation, but I'm overthinking the logic, so here it is. I want to create a Column into the flow of the dataset and call it, for ex, "HistoryDate" out of the following:

If the Amount column has any $$$ Value, I want this new column "HistoryDate" to display the Oldest Date out of the History_Created_Date column. Attached is a sample of data on what I'm looking to accomplish.

So for InvoiceNumber 00640lQAQ, the Historydate is expected to be 09/26/2021; for InvoiceNumber y00435uuh, the HistoryDate Expected to be 12/29/2021, and so on.

Thanks,

AJ

[FinnCharlton · Accepted solution]

Hi @AJ ,

Think you're looking for something like this?:

[AJ]

Thanks so much.