Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Folks,
I'm totally new to Power BI and I am just trying to upload data from excel to play about with. Looking advice on how to format the table below (which is a sample and includes 4 years worth of sales across the top and lists 1000 customers) . Before I actually get data what is the best layout ?? Any help much appreciated ...
Code | Cust Name | HomeDepot | SalesPerson | BuyingGroup Group Code | Feb 2018 | Jan 2018 | Dec 2017 | Nov 2017 | Oct 2017 | Sep 2017 | Aug 2017 | Jul 2017 | Jun 2017 |
DUB | x | DUB | IM | NT | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
VAN | y | VAN | IM | NT | 100.00 | 100.00 | 100.00 | 200.00 | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 |
Solved! Go to Solution.
Hi @Richard76,
You can unpivot table structure in Query Editor.
Best regards,
Yuliana Gu
Hi @Richard76,
You can unpivot table structure in Query Editor.
Best regards,
Yuliana Gu
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
80 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |