Forum Discussion

pbi_m1's avatar
pbi_m1
Frequent Visitor
8 years ago
Solved

Running Total

Hi I have been going through 10+ 'Running Total' entries and haven't found a solution to this one yet, so excuse if this is already solved.   DATE PROD_ID VALUE 2-Jul-18 A111 3 3-Jul-...
  • pbi_m1's avatar
    pbi_m1
    8 years ago

    Thanks Daniel. That's exactly solving it and way easier than CROSSJOIN.

pbi_m1's avatar
pbi_m1
Frequent Visitor
8 years ago

Hi v-danhe-msft,

 

Thanks for the prompt reply. Could it be that you responded to a different submission. I wasn't necessarily interested in the total value by month.

 

My main question was how to extend a running total column down for all dates in a table beyond the last date enty of e.g. PROD_ID = 'A111'. I have been invetigating the CROSSJOIN and LOOKUPVALUE functions, however, there are seem to be a few ways to build it and I'm still looking for how to do it most efficiently given CROSSJOIN (VALUES(Table[DATE]), VALUES(Table[PROD_ID])) can create quit a large subtable. I also realised that I can't create any Relationships between the CROSSJOIN subtable and the Table. 

 

Any comments are welcome,