Forum Discussion
Convert Monthly Cumulative (Running) Total to Monthly Absolute Totals
I have a dataset with monthly cumulative totals for all financial columns. Is there an easy way to convert the cumulative total in one column into an absolute monthly total instead? (Yes, I have...
For my uderstanding do u want keep single record for month ?
ya we can do. Share some sample data with expecting result .
i will help u to achieve your goal my dear friend .
Hello friend,
This is exactly what i want.
For example, consider the below image.
The data i have is in the cumulative form,
But i want it to be absolute, to transform the cumulative column using Power Bi into absolute column as in the image.
I hope you understood, please help.