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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
ConnorA
Frequent Visitor

Running sum between a Start Date and End Date Column

Hey all,

 

I am having an issue which I cannot seem to find a solution for. Its frustrating me because I believe the solution will be quite simple.

 

I want to create a bar graph that shows the rolling sum of a value between a start date and end date.

 

For example:

 

ValueStart dateend date
52021/04/102021/04/15
22021/04/102021/04/17
102021/04/152021/04/20

 

Now I want this to be in a bar graph (that shows every day, I created a Date Dimensions table to have every day of the year) but I want the rolling sum. Most bar graphs are only letting me use either the start date or end date as axis and therefore doesnt consider the rolling sum. For example: On 2021/04/15 the sum would actually be 17 because all 3 dates overlap on that date. The following day would be 12. 

 

I cant seem to think of an elegant way to do this, I even tried to see if there were any widgets that can address this. This is something I could do easily in excel but it must be in powerBI. 

 

Any ideas would be tremendously appreciated!!

 

 

1 ACCEPTED SOLUTION
Ashish_Mathur
Super User
Super User

Hi,

You may download my PBI file from here.

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

3 REPLIES 3
sgintowt
Helper I
Helper I

v-shex-msft
Community Support
Community Support

HI @ConnorA,

I'd like to suggest you take a look at the following link to create a expanded table for start date, end date analysis requirements:

Solved: Spread revenue across period based on start and en... - Microsoft Power BI Community

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Ashish_Mathur
Super User
Super User

Hi,

You may download my PBI file from here.

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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