Forum Discussion
New User - Bar Chart Keeps Adding Cumulative Total
- 2 years ago
1) The raw data I get it comes in cumulative format.Next time please lead with this crucial piece of information
see attached.
Okay. I went and made sure its not restricted. Didn't realize that. I would love to upload the PIBX here but not sure how. Thanks again.
Drop the cumulative column, it is not needed and can be replaced by a (quick) measure.
What you must have is a calendar table. I added that to your data model.
see attached.
- PowerBi2bPro2 years agoHelper I
Thank you again. I will need to learn a bit more to fully understand what you did. It seems very close, however here are some few additional hicups...
1) The raw data I get it comes in cumulative format. I manually did the QTR Calculation and added that column as I was thinking that there may be some way to use that. The way you did is awesome. I don't fully know the calcluation you used for the measure. it would be nice if you would explan it out here. I will google and try to learn and ask question in case that is preferred.
2) The reason why the current chart is not going to be accurate is that what we have in the QTR column is the DELTA. so the actual Loans receivable is cumulative from 2014 in the raw data. I need to reflect and discuss with management why they want it that way, but for now that's how its being created in the XL. So when we use only DELTA, we are missing about 12M of previously accumulated Loan Receivable Balance. that was the starting number in 2014 balance sheet.
I am not sure if I am making sence. Thanks again for putting this time and effor to help me. Much appreciated.
3) Lastly, I just can't understand why there is no SUM option for using the raw column data from the cumulative.
- lbendlin2 years agoSuper User
1) The raw data I get it comes in cumulative format.Next time please lead with this crucial piece of information
see attached.