Need to subtract from Previous row result to another column value.

[RuchiSharma]

Minimum product : Min(table[ Prod Name])

Min Prod Value=

Base-CALCULATE(sum('Table'[qty]),FILTER('Table','Table'[Oesc]=MIN('Table'[Oesc])))

"quantity (-) minimum prod value for ex: (10-0.02=9.98)

Need to consider the output of this previous row result (-) qty Ex: (9.98-0.03=9.95)

Formula: 10-0.02=9.98
9.98-0.03=9.95
9.95-0.04=9.91
9.91-0.05=8.86

[MFelix · Accepted solution]

Hi @RuchiSharma ,

For this you need to add a measure similar to this one:

Output = SUM('Table'[Base]) - CALCULATE(SUM('Table'[Qty]), 'Table'[Product NAme] <= MIN( 'Table'[Product NAme]))

Be aware that since the product names are in alphabeticle order the measure works properly, I believe that in your real data you will have an ID column so use that instead of the name on  the measure.

[RuchiSharma]

Hi @MFelix @Ashish_Mathur 
Slide changes came in the requirement Instead of subtraction we need multiplication can you please help me with how we can achieve this? Please refer below picture. I replaced the product name with Index so we can consider the index column as a product name.

[Ashish_Mathur]

Hi,

Please find attached my solution file.

Hope this helps.

[RuchiSharma]

Hi Ashish,
Can you please check answer is different.
I need an answer as per the below picture.
For Example:
0.02=0.2
0.0006=0.006

[Ashish_Mathur]

Hi,

Please find attached the PBI file.

Hope this helps.

[Ashish_Mathur]

Hi,

What's the criteria for determining the next row?  I am sure it is not the product name.

[RuchiSharma]

Hi @Ashish_Mathur 
It is the product name 
I have attached a screenshot for your reference 

Also, I mentioned the formula.

[Ashish_Mathur · Accepted solution]

Hi,

Please download my solution file.

Hope this helps.

[RuchiSharma]

Thank you so much @Ashish_Mathur  your Solution is working fine.❤

[Ashish_Mathur]

You are welcome.

[MFelix · Accepted solution]

Hi @RuchiSharma ,

For this you need to add a measure similar to this one:

Output = SUM('Table'[Base]) - CALCULATE(SUM('Table'[Qty]), 'Table'[Product NAme] <= MIN( 'Table'[Product NAme]))

Be aware that since the product names are in alphabeticle order the measure works properly, I believe that in your real data you will have an ID column so use that instead of the name on  the measure.

[RuchiSharma]

@Thank you So much @MFelix  Yes your solution is working fine ❤