Forum Discussion
Add a same value across selected time period
Hi, I have a per day project cost for different organization. This project has a start date and an end date. I found out how to visualize the per- day project cost across its course of time (i.e....
Yes you can do that. Did you try using the Running Total Quick Measure?
Also, check out my Time Intelligence The Hard Way Quick Measure here:
Basically, you just need to create a temp table that FILTER's your table to all rows with a date less than the current context and then do a SUMX on it.
Hi Greg,
Thanks for the reply. I tried using the new quick measure but it still does not add up the values over the range of selected dates/months/years.
SaurabhGupta,
Could you please re-share the PBIX file? I don't have access to the link you post.
Regards,
LydiaHi Lydia,
Here is the link:
https://drive.google.com/drive/folders/1WTPYJCLYDjJcoaf8dr8q4gPAk1X5H22w?usp=sharing
Thanks!