Forum Discussion
Insert value in new column and use EARLIER function
Hi guys, I have a question: I need to identify the first order (based on the date) for the person and insert "1" into the new column and for other orders (which are not first) insert 0. One per...
Ashish_Mathur
Super User
Super UserHi,
Try this calculated column formula
=IF(Data[Date Created]=CALCULATE(MIN(Data[Date Created]),FILTER(Data,Data[Personal id]=EARLIER(Data[Personal id]))),1,0)
Hope this helps.
Thank you Ashish_Mathur your formula was very useful!!! Sorry for the late reply :)