Forum Discussion

mmikemcgregor1's avatar
mmikemcgregor1
New Member
3 years ago
Solved

Hi all

I'm struggling to find the right method for my problem, open to either a Power Query solution or DAX.

I have a Budget Table that has my Current Spend by Month and my Monthly Budget. I created a measure to get my Rollover Budget (if not all of the Budget was used in one month then it can be rolled over to the next). But Im struggling on how to get my column E "Rollover + Monthly Budget". I need to apply th 8,000 from July's rollover to Augusts Budget so that August would show 28,000. 

 

Need Help
  • davehus's avatar
    davehus
    3 years ago

    Hi mmikemcgregor1 ,

    Please see solution below. I've created an offset in the column table. Let me know if this helps.

     

    Did I help you today? Please accept my solution and hit the Kudos button.

2 Replies

  • rsbin's avatar
    rsbin
    Community Champion
    3 years ago

    mmikemcgregor1 ,

    Can you please post the data as a table, not as an image. This will make it much easier to provide you with a solution.

    Thanks and regards,

  • davehus's avatar
    davehus
    Memorable Member
    3 years ago

    Hi mmikemcgregor1 ,

    Please see solution below. I've created an offset in the column table. Let me know if this helps.

     

    Did I help you today? Please accept my solution and hit the Kudos button.