Forum Discussion
Solved
Create a new table with first date
Hi, I want to create a new table from this one where all my cases are listed (only once) with the first date. Can someone help me? 🙂 BR
DataCruncher123 , A new table like this?
Summarize(Table,Table[Case], "Date", min(Table[Date create final]))
Fowmy
Super User
Super UserDataCruncher123
You can create a new table using the following code, it will remove duplicates except for the 1st record.
NewTable = Distinct('Your Table')________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂
That doesn't solve the problem. I need a table that shows the distinct cases and for each case the first date
- amitchandak
DataCruncher123 , A new table like this?
Summarize(Table,Table[Case], "Date", min(Table[Date create final]))
thanks a lot! 🙂
