Forum Discussion

Antonio_Flávio's avatar
Antonio_Flávio
Helper I
7 years ago
Solved

Criar KPI

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.

 

General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    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

3 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    7 years ago

    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