Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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. i want to create a measure that shows me the value for the "money" from the selected index value and the index value previous to the selected one. Also i want to have a measure for the text value from the selected index value.
I tried the formula below, but it does not seem to work. I only get a value for selected index filter, but not for the previous one. Can somebody help me?
Previous score = CALCULATE( SUM( 'subject_score'[Score]), Index[index] = MAX(Index[index) - 1), FILTER('subject_score', 'subject_score'[subject] = "Money"))
Thanks!
Solved! Go to Solution.
@Wilm117 , 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
@Wilm117 , 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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
45 | |
25 | |
19 | |
16 | |
8 |
User | Count |
---|---|
65 | |
50 | |
45 | |
20 | |
17 |