Actual and Budget with different granularity

joslaz

Board Regular
Hey, together


I'm currently facing a small challenge again.I have the following two tables.

TblActuals
Product IDGroupQuantity (Actual)Date
A1A10001.01.2019
A2A15002.01.2019
B1B5015.01.2019
B2B15016.01.2019
C1C2508.08.2019

<tbody>
</tbody>


TblBudget
GroupBudgetMonth
A500January
A500February
A550March
A600April
A100May

<tbody>
</tbody>



Now I would somehow connect both table so that I get displayed in a Pivot,
How much have I delivered per group so far (Actual) compared to the daily average for the budget.



In other words, I would have to somehow determine the budget by the number of working days and accumulated the Actuals against the daily budget. How is that possible?


Best Regards
Joshua
 

sandy666

Well-known Member
try merge these two table in PowerQuery (Get&Transform) by Group with Full Outer option then Expand to columns as you need
create PivotTable from the result
 

Some videos you may like

This Week's Hot Topics

Top