Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Track changes in Rows, post a value when occurs

Hi,    I want to track when a new Variant is being registered/produced in my dataset in the column changeover   My table looks similar to this   ID VARIANT Changeover 1 A   2 A 1...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    I solved it like this

     

    Match =
    VAR __prevRow = CALCULATE( MAX( 'Table'[ID] ) ) - 1
    VAR __PrevRowValue = CALCULATE( MAX( 'Table'[VAR] ), 'Table'[ID] = __prevRow )
    VAR __currRowValue = CALCULATE( MAX( 'Table'[VAR] ) )
    RETURN
    IF( __currRowValue = __PrevRowValue, 0, 1 )
amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , Create a new column like

 

new column =
var _max= Maxx(filter(Table, [ID] = earlier([ID])-1 ), [VARIANT])
return
if(_max =[VARIANT] ,1,0)

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    I solved it like this

     

    Match =
    VAR __prevRow = CALCULATE( MAX( 'Table'[ID] ) ) - 1
    VAR __PrevRowValue = CALCULATE( MAX( 'Table'[VAR] ), 'Table'[ID] = __prevRow )
    VAR __currRowValue = CALCULATE( MAX( 'Table'[VAR] ) )
    RETURN
    IF( __currRowValue = __PrevRowValue, 0, 1 )