Forum Discussion
Filtering the tables based on date and merging for comparison
I have two tables with the same fields. Just the difference between those two tables is the required delivery date. Both the tables have different excel sheet as their source as I am extracting dat...
3. In order to have a single row for each material, you can use the DAX formula:
Result = SUMMARIZE(Result, Result[Material], "Count of sales order", SUM(Result[Count of sales order]), "Confirmed quantity", SUM(Result[Confirmed quantity]), "Price current week", SUM(Result[Price current week]), "Price previous week", SUM(Result[Price previous week]), "Delta", SUM(Result[Delta]))