Forum Discussion
Get previous value from indexslicer dynamically with double filter context
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. Below you'll find an example of my data...
Anonymous , a new column
Sum(filter(Table, [Subject] = earlier([Subject]) && [Index] = earlier([Index]) -1) , [Score])
Use the correct table name
Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8
amitchandak
Super User
Super UserAnonymous , a new column
Sum(filter(Table, [Subject] = earlier([Subject]) && [Index] = earlier([Index]) -1) , [Score])
Use the correct table name
Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8