Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Calculation column for different row calculation

I need to create a new column to calculate column B.  what's the DAX i can use?  thanks!  
Need Help
marcelsmaglhaes's avatar
marcelsmaglhaes
Super User
7 years ago

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's avatar
    Anonymous
    Not applicable
    7 years ago

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

     

    thanks