Calculation column for different row calculation

Hey Anonymous ,

 You need to create a Previous Row Dax to perform this calc.

 Take a look on the picture. First, I create the measure Previous Row, to check the values and create a virtual column with values based on the previous row. After that, you can create a new measure to multiplicate: 

Multplication = Sum(Planilha1[Revenue])*[Previous Row]

 

Check if this resolve your problem.

 

Regards,
Marcel Magalhães

 

Hi,

Given column A, values in column B can be calculated.  I am sure your dataset is very different from what you have shared here.  Do you have a Date column in your dataset?  Share your data here.