Forum Discussion
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]))
4 Replies
- Fowmy
Super User
DataCruncher123
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]))
