Calculation column for different row calculation

[Anonymous]

I need to create a new column to calculate column B.  what's the DAX i can use?  thanks!

[Ashish_Mathur]

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.

[Anonymous]

no date required for this calculation, see below. 

[marcelsmaglhaes]

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

 

[Anonymous]

Sorry, I've updated my question. I need DAX for Column B, which I've got my calculation included in the ( ). 

thanks