Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Check previous values on same ID

Hey there!   I've got a question regarding the following: In my dataset I have the following columns   Customer ID |  Product  |  Up-to-date |  1                       TV                1 1   ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks for the swift reply!

When I try to use "if(countx(filter(table[Customer ID] = earlier([Customer ID]) && [Up-to-date]=0),[Up-to-date])+0>0,0,[Up-to-date])"

It doesn't let me select the first table[Customer ID], it wants a Table, not a column name.

 

Did I need to do anything beforehand, to make the column formula work?

 

ryan_mayu's avatar
ryan_mayu
Super User
5 years ago

Anonymous 

you can try this

Column = 
VAR _count=CALCULATE(COUNTROWS('Table'),FILTER('Table','Table'[customerID]=EARLIER('Table'[customerID])&&'Table'[up-to-date]=0))
return if(_count>0,0,'Table'[up-to-date])