Forum Discussion
Create Multiple Cumulative Columns
Hello, I've extracted a simple GL Dataset out of my GL (have it set up so I can extract by the month to keep things simple). Within PowerQuery (Get & Transform) I've shaped my data so that it's p...
Hi,
I would suggest that you unpivot your dataseta and have the GL codes in a single column. So your dataset should be a 3 column one - Date. GL code and Amount. From this dataset build your visual.
Hi Ashish,
Agreed on the unpivot, but prior to doing that, I need to get each GL column cumulatively summed downwards. is this possible without too much sophistication?