## Desktop

Frequent Visitor
Posts: 14
Registered: ‎06-07-2017

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

 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.

Accepted Solutions
Highlighted
Frequent Visitor
Posts: 14
Registered: ‎06-07-2017

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

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```

All Replies
Moderator
Posts: 8,804
Registered: ‎03-06-2016

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

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
Frequent Visitor
Posts: 14
Registered: ‎06-07-2017

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

[ Edited ]

It seems results are not correct.

Expected values are mentioned in red color

Highlighted
Frequent Visitor
Posts: 14
Registered: ‎06-07-2017

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

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```