Forum Discussion
how to reduce table size
Hi Anonymous
Can you try merge b/w OrdersDetailed and Orders table to Get OrderDate in OrdersDetailed table. Once done, you can filter OrdersDetailed based on OrderDate
= Table.NestedJoin(OrdersDetailed, {"Order ID"}, Orders, {"Order ID"}, "Orders", JoinKind.Inner)Thanks
Ankit Jain
Do Mark it as solution if the response resolved your problem. Do Kudo the response if it seems good and helpful.
Community ChampionHi Anonymous ,
Would it be possible to view the oldest date in your reduced table, look at the Order ID and go to the other table sort the table, and filter out all orders with an ID that is less than your Order ID. Assuming Order IDs are sequential.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Thanks Nathaniel_C . The problem is that there is not secuential, depends on the order type
for the type 1 the order ID is Alphanumeric, for the type 2 is numeric.. etc