Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
Can anyone assist me in creating a calculated column that is a running total of volume? I have two tables
- Receipt Table (Original table)
- RawPVM table (summarized the receipt table to get unique combinations of product codes and month/year
I summed the volume from the receipt table in a calculated column in the RawPVM table. I would like to calculate a running total of this aggregated sum by product code and month/year. Does anyone know how to do this? The values i'm getting aren't matching what i'm expecting to see as the current month is being excluded. For example:
In this example - i would expect the 'Rolling 12 Month Sum' column for 2/1/16 to have a value of 23800
Then 4/1/16 should be 30600, etc..
any ideas?
@murphm6 This shows how to create a running total:
And this one shows a rolling average, just replace AVERAGEX with SUMX:
Hey Greg,
That method doesn't consider the product code when doing the running total - i would like to have the running total be for the aggregate sum by code and date, not the total for the whole table
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |