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
Highlighted
marcelsmaglhaes
Regular Visitor

Re: Calculation column for different row calculation

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
ivyhai Post Patron
Post Patron

Re: Calculation column for different row calculation

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

 

thanks

Super User IV
Super User IV

Re: Calculation column for different row calculation

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/
ivyhai Post Patron
Post Patron

Re: Calculation column for different row calculation

no date required for this calculation, see below. 

PBI.PNG

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors