Forum Discussion
swan1099
Helper I
Helper ICreate 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...
swan1099Helper I
Helper IHi 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?
Seward12533
Solution Sage
Solution Sageswan1099have you tried a DAX table solution? I believe this would be the right approach. With the right filters and functions you can do single month, MTD, YTD, CumulativeTD, you may not even need the actual table but if you do SUMMARIZE should do the things trick.