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

 

IDVARIANTChangeover
1A 
2A1
3A1
4B0
5B1
6B1
7C0

 

 

Basically everytime that the previous row is not matching the next row, post changeover or 1 or 0 (W/E)

 

Blue equals desired state and is what i want to achieve

 

Hope someone can help

 

BR

Kristian

 

 

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 )

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper 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 )
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    amitchandak Thanks for your reply,

     

    I dont know if im doing it wrong but i get this result