RelationShip and Service Scoring Help

[skidambi2]

Hi Team,

I need help on how to take the below issue forward..

We need to implement Service Scoring for one our request were we have total count of tickets for each month and set a reduction for each services .

So we have given by default 4 points for each service .

What we want to achieve is the total tickets count for Jan 2019  has to compare with 2018 Jan with reduction and if its greater than 2018 then it should minus 1 point if its lesser it should add 1 point.

How can i achieve it 

[skidambi2]

Hello Sir,

Good Day.

I would like to attach a excel file but unable to do so to show you what is needed .

What is the best way could you please help

[v-danhe-msft]

Hi @skidambi2 ,

You could upload your file on OneDrive or Dropbox and send the link here.

Regards,

Daniel He

[skidambi2]

Thank you so much for the reply below is the link.

https://drive.google.com/open?id=1fxE-kIqCxUc4j9F5ABJD9RO6QdcVDB4u

Now if you see in the excel there are 4 tabs .

1) Metric 

It has around 4 products with Count of Tickets and then monthly tickets and we have a colum which is reduction .

So reduction is applied on Montly tickets and another colum is inital score which i have explained more in challenge

2) 2018 Load : This has total count of tickets for 2018 and  whatever count we get after appling reduction in Metric that values are called here in 2018 Load

3) 2019 Load : This has the total count of 2019 tickets for each product

4) Challenge : Here it compares the 2018 load january Count of tickets for a specific prodcut with 2019 load of that prodcut and if the count of 2019 is bigger than 2018 then that product gets -1 point and it reduces from metric inital score and if its great then it gives 1 point to the inital score.

Note : We have by default given 4 as a inital score to all products .

Maximum for each product the score can go from 1 to 5 only.

Please let me know how can i achieve it as i have already got the total count of ticket and i have created a sharepoint list with the reduction and inital percentage . I am not sure how to apply the challenge and reduction part in powerbi .

[v-danhe-msft]

Hi @skidambi2 ,

Could you please post some simple sample data and your desired result to have a test if possible? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Regards,

Daniel He