Criar KPI

[Antonio_Flávio]

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 · Accepted solution]

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

[Antonio_Flávio]

Thank you !

[v-frfei-msft]

Hi @Antonio_Flávio,

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

Regards,
Frank