Actual and Budget with different granularity
Results 1 to 2 of 2

Thread: Actual and Budget with different granularity
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    May 2018
    Posts
    56
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Actual and Budget with different granularity

    Hey, together


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

    TblActuals
    Product ID Group Quantity (Actual) Date
    A1 A 100 01.01.2019
    A2 A 150 02.01.2019
    B1 B 50 15.01.2019
    B2 B 150 16.01.2019
    C1 C 25 08.08.2019


    TblBudget
    Group Budget Month
    A 500 January
    A 500 February
    A 550 March
    A 600 April
    A 100 May



    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

  2. #2
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,555
    Post Thanks / Like
    Mentioned
    20 Post(s)
    Tagged
    1 Thread(s)

    Cool Re: Actual and Budget with different granularity

    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
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •