Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Add current value to previous row value (with condition)

Hello everyone,

 

Is there any way that I can do this in Power BI? I want to make column "calculations" using this formula.

 

 

Thank you in advance,

Milena

DAX Calculation
Help me
  • saraMissBI's avatar
    saraMissBI
    6 years ago

    Hi Anonymous ,

    Here is a solution to your problem. I am not sure if it is the most efficient solution, but it gives you the result needed.

    First, I added an index column from the query editor to the table to be able to catch the previous value of Type and Size. Then, I added a calculated column with the formula below:

    Please find the .pbix file here
    (N.B. I updated the file please make sure you refresh the page to get the correct file!)
    Please if that solves your problem, accept as solution and give kudos 🙂 
    Thank you!

2 Replies

  • saraMissBI's avatar
    saraMissBI
    Resolver I
    6 years ago

    Hi Anonymous ,

    Here is a solution to your problem. I am not sure if it is the most efficient solution, but it gives you the result needed.

    First, I added an index column from the query editor to the table to be able to catch the previous value of Type and Size. Then, I added a calculated column with the formula below:

    Please find the .pbix file here
    (N.B. I updated the file please make sure you refresh the page to get the correct file!)
    Please if that solves your problem, accept as solution and give kudos 🙂 
    Thank you!
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi saraMissBI ,

       

      Thank you so much, this works!

       

      I have one additional queston, what should I do if I want to subtract values from column "Number"?