TimeStamped Data - DateDiff for each unique Customer
Hi! I'd like to calculate the time it took for a person to advance from one stage to the next, and filter only those who are advancing.
I have a folder of 30+ excel files, each excel file has a huge list of unique customers who are in a certain subscription tier.
CURRENT (MESSY & SLOW) METHODOLOGY
I combine and load the data into an excel file using PowerQuery, sort by Customer Name, do the calculations there [ (C3-C2) * (A2=A3) * (IF(B2<B3),1,0) ] which returns the date diff only if the stage has advanced & comparing the same stage.
I'll make charts based on DateDiff and Revenue and other customer info to look for correlations.
Is there a way to use DAX to do this with a GROUPBY? Input example below. Thanks in advance!