Currently there is no way to express ordered iteration in DAX. This makes it impossible (or practically impossible) to calculate values where order matters. For example, I would like to be able to us...
PREVIOUS could also take an optional column name which would allow for quick shifting data. Here are a list of ideas that could also benefit from this proposal: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/38684635-dax-cumulative-total-by-previous-result-same-colu https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/37699576-add-table-calculation-dax-functions https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/37234996-running-total-for-declared-date-range https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/40079857-dax-function-to-create-column-with-shifted-rows
