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
Mahesh0016
Super User
Super UserAnonymous
* If this post helps, please consider accept as solution to help other members find it more quickly and Appreciate your Kudos.
I HAVE THOUSANDS OF LABELS I CAN´T USE A VARIABLE FOR EACH ONE. i NEED A MORE GENERIC SOLUTION THAT CREATE A NEW TABLE THAT I CAN WORK ON IT