Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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
Solved! Go to 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
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
80 | |
65 | |
52 | |
49 |
User | Count |
---|---|
212 | |
89 | |
79 | |
68 | |
60 |