Solved: Criar KPI

Antonio_Flávio · ‎10-05-2018

Olá galera estou querendo criar um KPI para mostrar a taxa de crescimento ou diminuição em comparação a outro mês.

No caso o KPI seria a porcentagem do Mês 08, do ano de 2018 vs 2017.

v-frfei-msft · ‎10-08-2018

I made one sample for your reference.

Firstly, we need to create a date table using the formula and create the relationship between the date table and the fact table.

Table = CALENDARAUTO()

Then we can create the measaures as below.

total sales = CALCULATE(SUM(Table1[sales]))

Previous = var previsou =CALCULATE(SUM(Table1[sales]),SAMEPERIODLASTYEAR(Table1[date]))
return 
IF(ISBLANK(previsou),BLANK(),([total sales]-previsou)/previsou)

Also please find the file attached.

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

v-frfei-msft · ‎10-08-2018

Hi @Antonio_Flávio,

I made one sample for your reference.

Firstly, we need to create a date table using the formula and create the relationship between the date table and the fact table.

Table = CALENDARAUTO()

Then we can create the measaures as below.

total sales = CALCULATE(SUM(Table1[sales]))

Previous = var previsou =CALCULATE(SUM(Table1[sales]),SAMEPERIODLASTYEAR(Table1[date]))
return 
IF(ISBLANK(previsou),BLANK(),([total sales]-previsou)/previsou)

Also please find the file attached.

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Antonio_Flávio · ‎10-11-2018

Thank you !

v-frfei-msft · ‎10-10-2018

Hi @Antonio_Flávio,

Does that make sense? If so, kindly mark my answer as a solution to close the case.

Regards,
Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.