cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

## 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.

1 ACCEPTED SOLUTION
Community Support

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.
3 REPLIES 3
Community Support

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.
Helper I

Thank you !

Community Support

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.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

#### Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors