Forum Discussion

vanessacalalang's avatar
vanessacalalang
Frequent Visitor
4 years ago
Solved

4month rolling total

Hi, Can someone helpme please?  I need to create a matrix to show  4months total of sales per client.  From this Sales table ( I just did mock up data in excel) I need to have  matrix in pow...
  • Anonymous's avatar
    Anonymous
    4 years ago

    HI  I add an index column , then calculate it in below formular. then you can delete index column

    = Table.AddColumn(#"Added Index", "Custom", each List.Sum(Table.SelectRows(#"Added Index",(a)=>a[Index]<=[Index]+3 and a[Index]>=[Index] and a[Clients]=[Clients])[Value]))

     

vanessacalalang's avatar
vanessacalalang
Frequent Visitor
4 years ago

Hi Jihwan_Kim, 


Sorry I missed your raw data. This is exactly what I need except I need to derive the "value" from the measure that I created as there are other calculations into it. Any advise on how can I get the SUM of the "measure" so I can use your brilliant formula? Thansk! 

Cheers,
Vanessa