Hi all,
I hope someone can help me with this. I'm new to Power BI, but have a bit of programming experiance. The logic of this makes sense to me, but I can't quite pinpoint a way to do it as a measure. And I do hope I explain this well, I struggle to wrtie down whats in my head.
- I have a table of projects with project ID, start date, end date, and period, which links to another table that has all the project budget details.
- I calculate our project value using the figures in our budget table
- I then calculate the daily value of a project - value/period
- I also have a table with all dates from today to today + 90 days.
What I'm looking for is a measure that will sum the daily value of the projects active in the selected date range.
eg:
Date Range: 20/05/2023 - 22/05/2023
Date: 20/5/2023
Projects Active on This Date: 555, 234, 128, 542
Daily Value of Each of These Projects: $600, $1000, $5000, $20
Sum of Daily Values for This Date: $6620
Thus, 20/5/2023 is worth $6620 to us.
Date: 21/5/2023
Projects Active on This Date: 234, 128, 542
Daily Value of Each of These Projects: $1000, $5000, $20
Sum of Daily Values for This Date: $6020
Thus, 21/5/2023 is worth $6020 to us.
Date: 22/5/2023
Projects Active on This Date: 234, 128, 542, 784
Daily Value of Each of These Projects: $1000, $5000, $20, $40
Sum of Daily Values for This Date: $6060
Thus, 22/5/2023 is worth $6060 to us.
...and so on...
I then want to plot that on a graph where Y = Daily Value Sum, X = Each Day.
This is easy enough to write in something like C#, but i'm struggeling to do it as a Power BI measure.
Thank you!
