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
I NEED TO CREATE A NEW TABLE TO DO CALCULATATIONS ON IT
Mahesh0016
Super User
Super UserAnonymous
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.