Forum Discussion
In DAX, can you loop through each value from a column variable in a SUMMARIZE table?
alerts = VAR EndOfWeekColumn = DISTINCT('DATE'[EndOfWeek]) RETURN UNIONX( SUMMARIZE(TABLE, Column1, Column2, etc, "New Column1", CALCULATE(...using the next value in EndOfWeekColumn...),...
Anonymous
You may take a look at the posts below.
- https://community.powerbi.com/t5/Desktop/Time-difference-between-next-row/td-p/338621
- https://community.powerbi.com/t5/Desktop/Dax-to-Sql-Windowing-Lag-function-Over-partition-by-equivalent/td-p/387698
- https://community.powerbi.com/t5/Desktop/Finding-the-previos-occurrence-within-same-table-based-on-one/m-p/342607#M153516
I also need a solution, I have the same problem