The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello everyone!
We have a budget table like this:
Area | Budget | Year-Week |
A | 5000 | 2020-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?
@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.
@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.
User | Count |
---|---|
16 | |
8 | |
6 | |
6 | |
5 |
User | Count |
---|---|
23 | |
13 | |
13 | |
8 | |
8 |