Forum Discussion
how to reduce table size
Hi all, I have two talbles: 1 - Orders Orders[date] Orders[Order ID] 2- OrdersDetailed OrdersDetailed[Order ID] OrdersDetailed[SKU] OrdersDetailed[QTY] Tables ...
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.
AnkitBI
Solution Sage
Solution SageHi 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.
thanks AnkitBI great job!