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.
v-qiuyu-msft
Community Support
Community Support
dplandry wrote:
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.
Hi dplandry,
Do you mean there is a common field sales order column between the archive table and order table, if that is a case, you can create a relationship between the archive table and order table with many to one. See: Create and manage relationships in Power BI Desktop.
But if you want to add additional rows of data from archive table to the main table, you can open Query Editor and use the feature Append Queries.
If I misunderstand the issue, please share some screenshots about the sample data and expected results for our analysis.
Best Regards,
Qiuyun Yu