Forum Discussion
Insert value in new column and use EARLIER function
Try this formula:
IF(Table1[Order Date]=CALCULATE(MIN(Table1[Order Date]),ALLEXCEPT(Table1,Table1[Personal ID])),1,0)Hi,
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.
Hi Anonymous,
By my tests, the solution from Ashish_Mathur and Arslan should be helpful.
If you have solved your problem, please accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please feel free to ask.
Best Regards,
Cherry
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 :)