Forum Discussion
sverderame
Helper I
Helper ICreating rolling totals with on-off filter capability
Hello, I am trying to create a rolling total. I am using excel and have 2 seperate worksheets. Worksheet #1 list many projects with savings that may or may not occure in the same year. I would li...
Greg_Deckler
Community Champion
Community Championsverderame Is this more of an Excel question with Excel formulas or ? Where does the Rolling Total column come from, is that part of your data or is that your desired outcome? If it is the desired outcome, where do the numbers come from?
sverderameHelper I
Helper IGreg_Deckler Its a PowerBi question. The running total lives in the excel spreadsheet. What I want to do is create a custom column in PowerBI that shows the effects (savings) of doing certain projects or not doing them. Essentially have a line graph that shows the baseline and each time a project is selected it would be reflected up or down.