Forum Discussion

aa8057's avatar
aa8057
Regular Visitor
10 years ago

Variance measure problem

Hi,   Looking for advice on how to calculate year on year variance using COUNT. Please can someone tell me how to do this? I want to count the number of Customer ID's by year and show the  +/- dif...
Need Help
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
10 years ago

Hi aa8057,

 

In your scenario, you can create a new table via expression:

 

Table = SUMMARIZE('RAW',RAW[Year of Application],"Count",COUNTA(RAW[Type of Application]))

 

Then create two calculated columns:

 

CountPrevious = calculate(SUM('Table'[Count]),filter('Table','Table'[Year of Application]=EARLIER('Table'[Year of Application])-1))


Difference = if('Table'[CountPrevious]=0, BLANK(), 'Table'[Count]-'Table'[CountPrevious])

 

 

 

For details, you can download the attached .PBIX file.

 

Best Regards,
Qiuyun Yu

 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

v-qiuyu-msft aa8057

 

The solution worked for me! Thanks. 

 

How would i incorporate a breakdown by month too? If I wanted to see the total count for this month versus this month last year?