Forum Discussion
Filtering the tables based on date and merging for comparison
This should give you a new table that contains a single row for each material, with the summarized values of the count of sales order, confirmed quantity, prices and delta.
Let me know if you might need further assistance.
Thank you for reverting on the question. It does not solve the problem. Let me try to explain more if it helps.
Excel 1 (current week data) - This has aprox 20 columns in source file
Excel 2 (Previous week data) - This also has aprox 20 columns as above in the source file.
I have used these sources to create table visuals by selecting specific columns of my choice and applying specific filters.
Table 1 - current week data is displayed and it includes calculated columns. Date filter of 1 Jan 2023 to 8 Jan 2023 is applied . Source is excel 1.
Table 2 - previous week data is displayed and it includes calculated columns. Date filter of 8 Jan 2023 to 15 Jan 2023 is applied . Source is excel 2.
I used to do this in excel and now I am doing it in powerBI to reduce my time for weekly reports.
In terms of excel, I would vlookup the material number from table 1 in table 2 and return the price value from table 2. This will give me current and previous week price columns side by side and then I can calculate the delta.
In powerBI - how can I merge the tables after I have applied date filter using slicer?