Forum Discussion
Solved
Check if a value exists previously
Hi, I would like to know how to create a new column where I get the value "New" if a person exists in previous months of my data and "Old" if it exists in previous months or if it's the first month ...
a new column =
var _1 = countx(filter(Table, [Person] = earlier([Person]) && [Date] < earlier([Date] ) ), [Person]) +0
return
if(_1 > 0, "Old", "New")
and if I want to check if it is NEW or OLD but only in last 5 weeks? So the range of date is 5 weeks before [Date]?