Forum Discussion

PrathSable's avatar
PrathSable
Icon for Advocate II rankAdvocate II
6 years ago

Divide previous row by next row

Hi Guys, I have the following data set:   Date Keyword Count 01-01-2020 ABCD 5 01-01-2020 DEFG 2 01-01-2020 HIGK 3 01-01-2020 LMNO 0 01-01-2020 PQRS 3 01-01-2020 ...
Need Help
PrathSable's avatar
PrathSable
Icon for Advocate II rankAdvocate II
6 years ago

nandukrishnavs :

 

I think I confused you, I do not want the percentage.

 I just want to divide earlier record with latest one & then that would need to be multiplied with a corresponding value.

 

Want to achieve this??

 

Suggestions?

 

Regards,

PrathSable

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi PrathSable ,

 

Incase you want to use Calculated Columns.

 

 

 

 

Previous Date =
CALCULATE (
MAX ( 'Table'[Date] ), FILTER(
ALLEXCEPT ( 'Table','Table'[Keyword] ),
'Table'[Date] < EARLIER( ( 'Table'[Date] ))
)
)
 
Previous Value =
CALCULATE (
MAX('Table'[Count]) , FILTER(
ALLEXCEPT ( 'Table', 'Table'[Keyword] ),
'Table'[Date] = EARLIER('Table'[Previous Date])
))
 
Divide Val = DIVIDE ('Table'[Previous Value],'Table'[Count])
 
Final Val = 'Table'[Divide Val] * 'Table'[Actual]
 
 

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)