cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ivyhai
Post Patron
Post Patron

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!

 

PBI.PNG

4 REPLIES 4
Ashish_Mathur
Super User
Super User

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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

no date required for this calculation, see below. 

PBI.PNG

marcelsmaglhaes
Frequent Visitor

Hey @ivyhai ,

 

 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
 previouRow.PNG

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

 

thanks

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.