How can I calculate the difference of scores between previous quarter and current quarter

[nandukrishnavs]

Date	Category	Score
01-01-2016	A	3
01-01-2016	B	2
01-01-2016	C	4
04-04-2016	A	2.5
04-04-2016	B	2.5
04-04-2016	C	4
08-08-2016	A	2
08-08-2016	B	3
08-08-2016	C	2
12-12-2016	A	3
12-12-2016	B	3
12-12-2016	C	3
02-02-2017	A	3
02-02-2017	B	2
02-02-2017	C	4
06-06-2017	A	3.5
06-06-2017	B	2
06-06-2017	C	2.5

In this table contain quarterly scores of different categories. How can i calculate the difference between previous quarter and current quarter in a calculated column.

[v-qiuyu-msft]

Hi @nandukrishnavs,

You can create a calculated column below: 

QuarterDiff(current-previous) = TOTALQTD(SUM('Table1'[Score]),'Table1'[Date],ALL(Table1))-CALCULATE(SUM(Table1[Score]),ALL(Table1),PREVIOUSQUARTER('Table1'[Date]))

Best Regards,
Qiuyun Yu 

[nandukrishnavs]

Hi  @v-qiuyu-msft

Thanks for the reply. 

It seems results are not correct.

Expected values are mentioned in red color

[nandukrishnavs · Accepted solution]

Hi @v-qiuyu-msft

I got the Dax query. Below query works for me.

CurrentQuarterScore-PreviousQuarterScore = 
VAR currentQuarterScore =
    CALCULATE ( SELECTEDVALUE ( Table1[Score] ) )
VAR selectedCategory =
    SELECTEDVALUE ( Table1[Category] )
VAR previousQuarterScore =
    CALCULATE (
        SUM ( Table1[Score] ),
        ALLEXCEPT ( Table1, Table1[Category] ),
        PREVIOUSQUARTER ( Table1[Date] )
    )
VAR difference =
    CALCULATE ( currentQuarterScore - previousQuarterScore )
RETURN
    difference