Forum Discussion
Remove cumulative total
- 8 years ago
Hi JurriaanQEL
Please see the attached file here.
Hope this helps. Here are the steps I performed
As you said we need an assistant field to undo the Cumulatives. So
First I created a "Parameter Table" to get "month number" in our Main Table
Then we can use this Calculated Column to get Monthly figuresMonthly Figure = VAR PreviousMonthValue = CALCULATE ( SUM ( Table1[Cumulative] ), FILTER ( Table1, Table1[Year] = EARLIER ( Table1[Year] ) && Table1[MonthNumber] = EARLIER ( Table1[MonthNumber] ) - 1 ) ) RETURN Table1[Cumulative] - PreviousMonthValue
Could you upload your file to one drive or googledrive
And share link here
Hi Zubair,
Thanks for the quick reply.
I've uploaded it, after stripping out some fields, data, etc (business information....)
https://1drv.ms/u/s!AiecK9GUkh9Aqyx8cBitsE4kZgW4
I hope I didn't remove too much.. I've left the fields I think should be there.
Thanks again.
Kind regards,
Jurriaan
Ps. I took a look at your website... nice stuff!
- Zubair_Muhammad8 years ago
Community Champion
Hi
I will get my hands on laptop in 2 to 3 hours
Replying from my phone
I will do my best- JurriaanQEL8 years agoRegular Visitor
No rush, I am calling it a day soon anyway and I am more than grateful for you giving it a try anyway!
- Zubair_Muhammad8 years ago
Community Champion
Hi JurriaanQEL
In the file you sent, there is no relationship between the dim_date and v_f_Bordereau tables.
When I create a relationship,the left table shows both Cumulative and Monthly Figures.
Right table has missing fields (probably because you deleted some data). So it is not showing up in the File You sent