cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Como criar tabela Power BI / How to create a Power BI table

Tenho a seguite dúvida, tenho este schema de dados:

I have a question, I have this data schema:

 

Captura de Tela (269).png

 

Gostaria de realizar uma tabela assim:

I would like to do a table like this:

Ano     Quantidade

2018    83.579

2017    546.001

2016    898.221

Captura de Tela (270).png

 

 

 

1 ACCEPTED SOLUTION
v-piga-msft
Resident Rockstar
Resident Rockstar

Hi @Antonio_Flávio,

 

You need to do something change in Query Editor like below. Please follow the steps:

 

1. Go to Query Editor and selecet ANO_ATUAL and click Pivot Column under Transform.

 

pivot 2018.PNG

 

2. Do the same option for 2017 and 2016.

 

3. Select column 2017,2018,2016 and click Unpivot.

unpivot.PNG

 

4. Then you could create the calculated table with the formula below.

 

Table 2 = SUMMARIZE('Table','Table'[Year],"Q",SUMX('Table','Table'[Value]))

Here is the result.

result.PNG

 

For more details, you could have a reference my attachment.

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-piga-msft
Resident Rockstar
Resident Rockstar

Hi @Antonio_Flávio,

 

You need to do something change in Query Editor like below. Please follow the steps:

 

1. Go to Query Editor and selecet ANO_ATUAL and click Pivot Column under Transform.

 

pivot 2018.PNG

 

2. Do the same option for 2017 and 2016.

 

3. Select column 2017,2018,2016 and click Unpivot.

unpivot.PNG

 

4. Then you could create the calculated table with the formula below.

 

Table 2 = SUMMARIZE('Table','Table'[Year],"Q",SUMX('Table','Table'[Value]))

Here is the result.

result.PNG

 

For more details, you could have a reference my attachment.

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi@v-piga-msft

 

exactly the answer,

Thank you

 

Cherry.

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.