Forum Discussion
filter a table
I HAVE THIS TABLE Label Data A 20/10/2022 A 20/11/2022 A 10/12/2022 B 15/10/2022 B 25/11/2022 HOW TO FILTER THE TABLE T...
If you can do something with a measure, you should consider that before creating additional tables and/or columns. However, this expression should give you the table you need (update with your actual table name).
New Table = SUMMARIZE ( TABLE, Table[Label], "MinDate", MIN ( Table[Data] ) )Pat
AbbasG
Memorable Member
Memorable MemberAnonymous you can filter the date column by earliest as below to get your desired output.
I NEED TO CREATE A NEW TABLE TO DO CALCULATATIONS ON IT
- Mahesh0016
Super User
Anonymous
Try this one....
Table 2 =CALCULATETABLE(SUMMARIZE(Filter_Tables,Filter_Tables[Label ],"Date",FIRSTDATE(Filter_Tables[Data])))Note : Your Date is Asc order .
*If this post helps, please consider accept as solution to help other members find it more quickly and Appreciate your Kudos.
