Guest Story: Unpivot Pairs of Columns
Our guest today is Sandeep Pawar. A Simulation & Data Analytics Engineer at Cree Lighting in Racine, WI. Sandeep applies Data Analytics, Statistics, and...
Search Results for: unpivot
Answer for Ch 7 Unpivot
Hi Nazim,Thank you for reporting this issue. When I open C07E02.pbix file I can see the function in the Power Query Editor (click Edit Queries to see it in the...
Ch 7 Unpivot
I have purchased ur book and I am really enjoying it. There is a problem with 7-2 wherein u have laid a function fxunpivotsummarised tables. While taking it in...
Unpivot Bug in Power Query
May 2017 Update: This article describes a bug that is already fixed in Power BI Desktop, May update. You can now use the Unpivot Only Selected Columns, and...
Split and Unpivot Comma-Separated Values
By now, if you read my previous posts in the series The Definitive Guide to Unpivot in Excel (all posts here), you will feel confident with the following...
Unpivot ANY nested table and load to Power BI Desktop
Earlier today I shared with you a function query here that unpivots ANY nested table into Excel and transforms summarized tables into a PivotTable. This post...
Transform already-pivoted tables to PivotTable (The Definitive Guide to Unpivot with Power Query in Excel)
This post is the first in a series of posts that will walk you through one of the coolest data transformation features in Excel. If you are not familiar with...
Unpivot Any table in Excel 2016
My Unpivot series just got published on Office Blogs here. Enjoy reading...
Handling Excel Formula Errors in Power Query
Earlier this month I published a new and very practical Power BI app on Microsoft AppSource. The app audits Excel workbooks and detects changes and...
Automatically remove empty columns and rows from a table in Power BI
Hi again. This is Maya (you can find me on Linkedin here), with my second post on DataChant: a revision of a previous tutorial. Removing empty rows or columns...
