Calculate if a value is repeated or not in a sequential manner

[Jo5hua22]

Hi

I would like to know the DAX command to determine if the next row has the same value as the current row. Can  you please help me out? I have provided an example for better explanation

Example:

[amitchandak · Accepted solution]

@Jo5hua22 , A new column

var _seq = [S.No]
var _last = countx(filter(Table, Table[S.No] = _seq -1 && [KPI] = "R"),[S.No])
var _Next = countx(filter(Table, Table[S.No] = _seq +1 && [KPI] = "R"),[S.No])
return
Switch(True() ,
[KPI] = "R" && isblank(_last) && isblank(_next) , "No Check",
[KPI] = "R" && not(isblank(_last)) && isblank(_next) , "Check",
blank())

[tamerj1 · Accepted solution]

Hi @Jo5hua22 

This calculated column should work:
Output =
IF (
NOT ISBLANK ( Table[KPI] ),
IF (
NOT ISBLANK ( LOOKUPVALUE ( Table[KPI], Table[S.No], Table[S.No] - 1 ) ),
"Check"
)
)

If ok, please consider marking my reply as accepted. Thank you!

[amitchandak · Accepted solution]

@Jo5hua22 , A new column

var _seq = [S.No]
var _last = countx(filter(Table, Table[S.No] = _seq -1 && [KPI] = "R"),[S.No])
var _Next = countx(filter(Table, Table[S.No] = _seq +1 && [KPI] = "R"),[S.No])
return
Switch(True() ,
[KPI] = "R" && isblank(_last) && isblank(_next) , "No Check",
[KPI] = "R" && not(isblank(_last)) && isblank(_next) , "Check",
blank())

[Jo5hua22]

Hi @amitchandak 

I tried your code but I am getting blank columns as the output. Can you share the pbi file that you did?

[amitchandak]

@Jo5hua22 ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.