Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Get previous value from index slicer dynamically DAX

Hi everybody,   I am creating a report for which I use and index slicer. I want to compare a value from the current selection with the value previous to the current selection.   Index Project...
Slicer
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Now i have an additional question of which I hoped would have been solved by your solution, but it isn't.

 

CALCULATE ( SUM ( Data[Value] ), Data[Index] = MAX ( Data[Index] ) - 1 )

 

There is an additional filter that I want to include to this formula. I want to add another filter in this formula in which i select for a specific value in another table. 

 

Previous score = 
CALCULATE( 
SUM( 'subject_score'[Score]),
 Index[index] = MAX(Index[index) - 1),
 FILTER('subject_score', 'subject_score'[subject] = "Money"))

 

With this addition the value does not show in my table. Am i doing something wrong while using a double filter?

new data example:

 

Thanks already!