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...
DataNinja777
Super User
Super UserMy observation is that for your Expense Calc measure, you do not need to input hard corded "April" month, and similarly for your Income Calc, you do not need the hard coded "April" month filtering.
Your [percent diff] measure is just the margin and I wouldn't call it as percent diff as it is not describing what it is.
DataNinja777 thanks for the reply. I tried removing April but am getting error message (see screenshot below). Any help would be appreciated.
- DataNinja777
Dax is like an excel formula. You can delete the blue crossed out part.
Best regards,
