Forum Discussion
Comparison against Previous Record
Hello, I'm new with DAXand my logic is still with Excel. Using Calculated Column with DAX (not in Power Query), how do I check my current record against previous record? Data Desired ...
JustDavid You are going to need to add an Index to your table to be able to let DAX know what "before" is.
Sorry...I don't quite understand.
Even if I were to add an index column (I'd assume starting from 0), in which formula do I use it in?
Is it in VAR __PreviousData = MAXX(FILTER('Table','Table'[DATA] < EARLIER('Table'[DATA])),[INDEX])?
Again. How do I assign value 1 to the 1st record of the column 'Desired Result'?
Just to be clear, This is the logic that I had with Excel.
- Put a value 1 in the 1st record in column 'Desired Result'.
- Add a counter: Add a counter to 'Desired Result' column from the previous record of [DESIRED RESULT] IF AND ONLY IF when the current record [DATA] is not the same as the previous record [DATA] i.e. Use previous row value from the 'Desired Result' + 1 If current record [DATA] is NOT the same as previous record of the [DATA].
- Do not add counter: Take the value from 'Desired Result' column of the previous record of [DESIRED RESULT] IF AND ONLY IF when the current record [DATA] is the same as the previous record [DATA] i.e. Use previous row value from the 'Desired Result' If current record [DATA] is the same as previous record of the [DATA].