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

[Antonio_Flávio]

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

I have a question, I have this data schema:

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

[v-piga-msft · Accepted solution]

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.

2. Do the same option for 2017 and 2016.

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

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.

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

Best Regards,

Cherry

[Antonio_Flávio]

Hi@v-piga-msft

exactly the answer,

Thank you

Cherry.