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.
Good afternoon,
i hope you can help me. To correctly link parameters to equivalent in the model I separated using "split column" the year from the three elements QTY, Av. net sell and Turnover.
Now I would need to separate in three different columns: QTY, Av. net sell. and Turnover, so that for each Part number and each year I have the three values, but in independent columns.
Is there a command to do so?
Thank you very much!!!
Fabio
Solved! Go to Solution.
Hi @Duinhir
Highlight the Attribute.2 column, go to the Tranform tab in the ribbon then choose Pivot column. Use the Value column in the Value field. In Advanced Options, Choose Don't Aggregate
Hope this helps
Joe
Proud to be a Super User! | |
Date tables help! Learn more
Hi @Duinhir
Highlight the Attribute.2 column, go to the Tranform tab in the ribbon then choose Pivot column. Use the Value column in the Value field. In Advanced Options, Choose Don't Aggregate
Hope this helps
Joe
Proud to be a Super User! | |
Date tables help! Learn more
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 | |
76 | |
63 | |
51 | |
48 |
User | Count |
---|---|
204 | |
86 | |
64 | |
59 | |
56 |