Forum Discussion
EXTRACT DATA FROM TABLES BEFORE ARCHIVE
Hey guys I'm pretty new to Power BI, but am learning fast and loving it. I am trying to build a report on deleviry effeciency, but the main table I need to use to pull data is archived such tha...
I'm having a problem linking the current table to the archive table. In the order table, the sales order appears once. The archive table holds sales order lines so the sales order appears more than once so I'm having issues linking them. If I use the main table, I only get 6 months of sales orders.
MEhrenmueller
Most Valuable Professional
Most Valuable ProfessionalCan you support me with more details about the (useful) columns of both tables?
From the knowledge I have so far about your case, it should be possible to GROUP the archive table when you load it via Power Query, so you get down to the expected number of rows.