Forum Discussion

mohany2211's avatar
mohany2211
Frequent Visitor
7 years ago
Solved

Difference between two rows

Hi..........i am trying to calculate the revenue growth between the two dates and based on criteria from another column, but not able to apply the correct formula. can someone help me with a formula ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi mohany2211,

     

    In Previous Value you can use ABS(PreviousVaue). After return statement in my dax you can change this.

     

    "
    Return
    DIVIDE((CurrentValue-PreviousValue),ABS(PreviousValue)) "

     

    I am also attaching Pbix file with update. Please follow the link Remarks.pbix

     

    Best Regards, 

    Ravi

     

     

mohany2211's avatar
mohany2211
Frequent Visitor
7 years ago

Dear Ravi...thanks for the same. However...my issue is if previous figure is negative and current figure is poistive than also growth is coming as -ve refer table in my previous post.

 

Can you pls help how to rectify that

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi mohany2211,

 

In Previous Value you can use ABS(PreviousVaue). After return statement in my dax you can change this.

 

"
Return
DIVIDE((CurrentValue-PreviousValue),ABS(PreviousValue)) "

 

I am also attaching Pbix file with update. Please follow the link Remarks.pbix

 

Best Regards, 

Ravi