Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
joshua1990
Post Prodigy
Post Prodigy

Determine Weekly Budget on Daily Level and accumulate

Hello everyone!

We have a budget table like this:

AreaBudgetYear-Week
A50002020-05

 

Now I would like to divide the weekly budgets by 5 to get the daily budget.

Then I would like get a running total on a daily level.

 

How is that possible?

I simple DIVIDE is not working.

What did I forget?

3 REPLIES 3
Anonymous
Not applicable

That's easy. Instead of having a table with weekly budgets, create a table (in PQ or DAX) with day by day allocation. Then, the sum on the week level will be the same as the original table but the advantage is that you'll also have your budgets allocated to each and every day of the week.

Best
D
amitchandak
Super User
Super User

@joshua1990 , you want to create a daily allocation table?

You can check this file. Not from the week. But the idea is the same.

https://www.dropbox.com/s/fnq82ksdzk1lqs3/Target_allocation_daily.pbix?dl=0

 

Why are you not able to divide?

 

For Week calendar and week related stuff refer these two.

https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...

https://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Powe...

 

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Greg_Deckler
Community Champion
Community Champion

@joshua1990 - Hmm, well here is a measure with a similar goal:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Revenue-Reverse-YTD/m-p/373185#M111

 

That being said, seems like you might need to use something like GENERATESERIES or something to generate a daily table. Or create a Calendar table with all of your individual days and then create a new column and essentially look up the week in your budget table, get the budget, divide by 5. 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.