Forum Discussion

swan1099's avatar
swan1099
Helper I
8 years ago

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...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

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.

  • swan1099's avatar
    swan1099
    Helper I
    8 years ago

    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?

    • Seward12533's avatar
      Seward12533
      Solution Sage
      8 years ago
      swan1099have 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.
    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      8 years ago

      Don't know.  Sorry.