Forum Discussion

alanvicsansz's avatar
alanvicsansz
Frequent Visitor
2 years ago
Solved

How to Adjust Service Measures Based on Date Range

Hello everyone, good evening! I hope you are all doing well. I would like to share the challenge I am currently facing regarding the performance measures of the customer service team.   Context of...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi alanvicsansz ,

     

    I've made a test for your reference:

    1\Add two caculate column for Ocorrencias

    Year = YEAR(Ocorrencias[data_ocorrencia])
    Month = MONTH(Ocorrencias[data_ocorrencia])

    2\Set these two measure

    Ano atual = 
VAR MaxYear=YEAR(CALCULATE(MAX(Ocorrencias[data_ocorrencia]),ALLSELECTED(Ocorrencias)))
Var MaxMonth= MONTH(CALCULATE(MAX(Ocorrencias[data_ocorrencia]),ALLSELECTED(Ocorrencias)))
RETURN
CALCULATE(COUNTROWS(ALLSELECTED(Ocorrencias)),Ocorrencias[Month]=SELECTEDVALUE(Calendario[MesNum]) && MaxYear=Ocorrencias[Year] && Ocorrencias[Month]<=MaxMonth )
    Ano anterior = 
VAR MaxYear=YEAR(CALCULATE(MAX(Ocorrencias[data_ocorrencia]),ALLSELECTED(Ocorrencias)))-1
Var MaxMonth= MONTH(CALCULATE(MAX(Ocorrencias[data_ocorrencia]),ALLSELECTED(Ocorrencias)))
RETURN
CALCULATE(COUNTROWS(ALLSELECTED(Ocorrencias)),Ocorrencias[Month]=SELECTEDVALUE(Calendario[MesNum]) && MaxYear=Ocorrencias[Year])

     

    Best Regards,

    Bof

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi alanvicsansz ,

 

I've made a test for your reference:

1\Add two caculate column for Ocorrencias

Year = YEAR(Ocorrencias[data_ocorrencia])
Month = MONTH(Ocorrencias[data_ocorrencia])

2\Set these two measure

Ano atual = 
VAR MaxYear=YEAR(CALCULATE(MAX(Ocorrencias[data_ocorrencia]),ALLSELECTED(Ocorrencias)))
Var MaxMonth= MONTH(CALCULATE(MAX(Ocorrencias[data_ocorrencia]),ALLSELECTED(Ocorrencias)))
RETURN
CALCULATE(COUNTROWS(ALLSELECTED(Ocorrencias)),Ocorrencias[Month]=SELECTEDVALUE(Calendario[MesNum]) && MaxYear=Ocorrencias[Year] && Ocorrencias[Month]<=MaxMonth )
Ano anterior = 
VAR MaxYear=YEAR(CALCULATE(MAX(Ocorrencias[data_ocorrencia]),ALLSELECTED(Ocorrencias)))-1
Var MaxMonth= MONTH(CALCULATE(MAX(Ocorrencias[data_ocorrencia]),ALLSELECTED(Ocorrencias)))
RETURN
CALCULATE(COUNTROWS(ALLSELECTED(Ocorrencias)),Ocorrencias[Month]=SELECTEDVALUE(Calendario[MesNum]) && MaxYear=Ocorrencias[Year])

 

Best Regards,

Bof

 

 

alanvicsansz's avatar
alanvicsansz
Frequent Visitor
2 years ago

It worked perfectly, this was the result I was looking for, thank you very much. 💪🤝