Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

How to add previous row value with current one and then keep getting the summation

HI below is the table as input in power bi and below that is the output i would require in power bi. Please let me know how is it possible in calculated column or Measure. its basically addition of p...
Data Modeling
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    8 years ago

    Hi Anonymous,

     

    You can create a calculated column: 

     

    Column = CALCULATE(SUM('Table3'[Value]),FILTER('Table3','Table3'[Date]<=EARLIER('Table3'[Date])))

     

     

    Best Regards,
    Qiuyun Yu 

v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi Anonymous,

 

You can create a calculated column: 

 

Column = CALCULATE(SUM('Table3'[Value]),FILTER('Table3','Table3'[Date]<=EARLIER('Table3'[Date])))

 

 

Best Regards,
Qiuyun Yu 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    @v-qiuyu-msft thanks for the solution, it was exactly what I was looking for. I just have another question. Is it possible to perform the same calculation using a measure? If not, not a problem.

    • v-qiuyu-msft's avatar
      v-qiuyu-msft
      Icon for Community Support rankCommunity Support
      7 years ago

      Hi Anonymous,

       

      Of course. You can create a measure below: 

       

      Measure=CALCULATE(SUM('Table3'[Value]),FILTER(all('Table3'),'Table3'[Date]<=Max('Table3'[Date])))

       

      Best Regards,
      Qiuyun Yu 

      • PowerSaso's avatar
        PowerSaso
        Regular Visitor
        6 years ago

        Hi v-qiuyu-msft ,

         

        your formulas really helped me a lot. Now I have the question if the same calculation can be made in Power Query (Custom column)?

        Link to image . Cuz I want to use my calculated columns in Data pane (Link to image ) as an import into new Power Queries.

         

        Thanks a lot in advance.

        Best regards

        Saso

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    v-qiuyu-msft 

     

    Hi,

     

    Is it possible to do this for each week? I mean summing the values per week.

     

    Thanks.

  • mluanacruz's avatar
    mluanacruz
    Icon for Helper I rankHelper I
    4 years ago

    Hello!! This is pretty much what I need but based on columns like in the picture below. Can I add a measure to add columns 2 into column 1, column 3 into colunm 2....

     

     

    Thank again for the help.

     

    Michelle