Forum Discussion
adavid999
Helper V
Helper VSimple calculation
Hi, Please could you remind how best to acheive this...I have table data and would like a new column or measure that shows sum of score for each question based on year, so total for question 1 would...
amitchandak
Super User
Super UserIf plot sum(Table[Score]) By question and year it should give you that
Or you want this year vs last year
This Year = calculate(Sum(Table[Score])filter(all(Table),Table[Year] =max(Table[Year])))
last Year = calculate(Sum(Table[Score])filter(all(Table),Table[Year] =max(Table[Year])-1))
adavid999Helper V
Helper VThanks for quick response amitchandak . I need the result of sum for both years to be used in another calculation. There are many questions, with many different potential filters to view the scores. I'm not sure if plot sum(Table[Score]) will get me there, but will try.