Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
Hello all - Looking for some help that I've been staring at this too long, and it's probably easy, and I'm a novice DAX user.
I have the following code which is creating a "ideal budget burndown", which is straightline from the beginning of the year (total budget), and reducing to 0 at the end of the year.
Any help would be appreciated.
Solved! Go to Solution.
Hi,
You may download my PBI file.
Hope this helps.
Hi,
Share some data to work with and show the expected result.
I put together a sample power bi workbook which should help. Here's a onedrive link to the file. https://1drv.ms/u/s!AuWIDCM8OerBhs03N9xk_o7yY-GLpQ?e=84p73B
Documented on the page is an example, bad and desired.
Thanks Ashish - this gives me exactly what I needed, and I'll walk through the DAX to be sure I understand it. @rbriga thank you too, your's was very helpful in this conversation also.
You are welcome.
@rbriga thanks for the suggestions.
For #1 - I am connected to the calendar, which is part of what confuses me, as the calendar has all of 2023 and Jan 1 2024. I'm ok with seeing 2024, but only Jan 2024 (which was missing), and the rest of 2024 shoudlnt be there at all. The goal being I need to see the burndown visibliy show "0" on Jan 2024. (it's really dec 31, but all the data is aggregated already at monthly before I receive it)
For #2 - I would use suggestion #2 but unable because when I expand this beyond the test data set, some budgets will start mid-year, not always divisible by 12. (but I like this idea)
Do you have another suggestion to augment on #1, so I "can" see Jan 2023->Jan 2024 (inclusive) to show the complete burdown to 0?
Thanks!!!
Not seeing January at 0 is an expected result.
My suggestions:
A) If you had a budget fact table- year, budget. Connect it to the calendar table using the year.
Then, 2024 won't show up unless it has a budget value.
or
B) Define a single, yearly budget as a measure.
The burndown would be:
(13-MONTH(MAX('TEST_Calendar'[Date])) * DIVIDE([Yearly Budget],12)
This would return 1/12 of the budget per month from the end of the year.
User | Count |
---|---|
93 | |
92 | |
85 | |
83 | |
49 |
User | Count |
---|---|
150 | |
142 | |
112 | |
73 | |
55 |