by Gil Raviv | Jan 21, 2017 | Popular
If you have missed my webcast on Global Power BI User Group, you can now watch the recording, and download the Power BI files (details below). Subscribe to DataChant to get access to the PBIX files that were used in the webcast. Once you confirm your email, you will...
by Gil Raviv | Jan 13, 2016 | Popular, Unpivot - The definitive guide
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 challenge: How to split comma-separated values in Power Query. We have a table of event names, dates and...
by Gil Raviv | Jan 3, 2016 | Popular, Unpivot - The definitive guide
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 will show you how to import the function query and use it in Power BI Desktop on any table you load from...
by Gil Raviv | Jan 3, 2016 | Power Query, Unpivot - The definitive guide
Get ready to be amazed 🙂 This is the fourth post in the series The Definitive Guide to Unpivot with Power Query in Excel. In this series we walk you through one of the coolest data transformation features in Excel – The Unpivot transformation. Powered by Power...
by Gil Raviv | Jan 3, 2016 | Power Query, Unpivot - The definitive guide
This is the third post in the series The Definitive Guide to Unpivot with Power Query in Excel. In this series we walk you through one of the coolest data transformation features in Excel – The Unpivot transformation. Powered by Power Query technology, the...
