Forum Discussion
Solved
How to calculate dynamic percentage difference from the same column
Hello all, I am trying to calculate dynamically the percent difference using Price values from the same column and using filter context from two different columns (Month and Type) I have bee...
Hi trying2learnpbi ,
I hope this below Measures will help you,
Measure 1:
Measure 2:
Measure 3:
Dynamically it will work.
Best Regards,
Ajith Kumar
If it solves your issue, please accept it as the solution to help the other members find it more quickly.
Ajithkumar_03 thanks for your reply. I tried your format but am getting the error below. It is weird since the Type column has two values (income and expense).