Create a new table with first date

[DataCruncher123]

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

[Fowmy]

@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 🙂

Website YouTube  LinkedIn

[DataCruncher123]

That doesn't solve the problem. I need a table that shows the distinct cases and for each case the first date

[amitchandak · Accepted solution]

@DataCruncher123 , A new table like this?

Summarize(Table,Table[Case], "Date", min(Table[Date create final]))

[DataCruncher123]

thanks a lot! 🙂