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.
Hello!!!
I have a table connected to SQL that outputs a column for each month.
For working it better in Excel, I need to transforme that 12 columns to only 2... a first one for the values and the second for the respective month (that at this moment are the column titles).
In your opinion, which will be the better option (or if it dependes, advantages and desavantages):
a) a SQL command (not familiar to me);
b) use unpivot in Query Edit
Solved! Go to Solution.
Using the Unpivot feature in the Query Editor should work, but just keep your eye on how long it takes. If it can handle the transformation in an acceptable time, this will be the easist way to manage it.
If you are talking big data volumes then SQL will be faster, but the SQL will be more complex.
Using the Unpivot feature in the Query Editor should work, but just keep your eye on how long it takes. If it can handle the transformation in an acceptable time, this will be the easist way to manage it.
If you are talking big data volumes then SQL will be faster, but the SQL will be more complex.
So SQL it may be the best solutions in the long term, because I wil not to worry if the Query Editor handles diferent databases.
Thank you so much.
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 |
---|---|
113 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |