Forum Discussion
Solved
Calculated column which can evaluate other rows in the table with the same value?
Hello, I am working on an issue where I think I understand the logic behind what needs to happen, but I am not sure of the DAX to make it work. Here is some example data: Person ID Year ...
passants ,
new column
= var _cnt = countx(filter(Table, [Person ID] = earlier([Person ID] ) && [Year] = earlier([Year] ) +1) , [Person ID])
return
if(isblank(_cnt), false() , true())
amitchandak
Super User
Super Userpassants ,
new column
= var _cnt = countx(filter(Table, [Person ID] = earlier([Person ID] ) && [Year] = earlier([Year] ) +1) , [Person ID])
return
if(isblank(_cnt), false() , true())