Query performance of CALCULATE function in DAX
Recently, I’ve been working with a large inventory dataset (1.8M transactions), and trying to find ways to identify the sequence of transactions. The dataset is very simple, with an assetID, a transaction date, and a transaction ID. The latter is …..