Forum Discussion
MrHajiCoolBreez
1 year agoFrequent Visitor
Getting the Previous Value in a Matrix with 7 rows
I have a Matrix which looks like this I have 7 Columns in ROWS "EndOfSnapShotWeek" in the COLUMNS and "Rev1" and "Rev2" in the VALUES I want to create two measures that will calculate ...
- 1 year ago
You have interesting data including negative numbers. Calculating a WoW with a mix of positive and negative numbers is extremely subjective. Make sure you agree with the formula.
Here's my (subjective) version:
Rev1 change = var pr1 = CALCULATE(sum(test[Rev1]),DATEADD('Calendar'[Date],-7,DAY)) return divide(sum(test[Rev1])-pr1,abs(pr1),1)However your x axis is driven by a fact date (end of snapshot week) and not by the dimension date as it should be . You will want to correct that too ( or modify the above formula)
lbendlin
Super User
1 year agoAs you can see in my example I included a neutral area of +/- 5%. Feel free to modify that.
MrHajiCoolBreez
1 year agoFrequent Visitor
Cool, thanks. All working now