|Help, I received a pivoted data file that I want to combine with my data in PowerPivot|
|Written by Kasper de Jonge|
|Friday, 03 May 2013 20:31|
Often when working in Excel you get all kinds of flattened files that come from all kinds of different source and you want to use as them as a source for your analysis. Today we are looking at how DataExplorer can help you with this. Click here to download DataExplorer, for more details on Data Explorer check out my previous blogs.
Image we have the following Products with revenue for the following fiscal year and month. This data comes from your nicely structured datawarehouse:Read more...
Latest Author Articles
- Dynamic format using DAX
- Parallel partition processing available for Tabular Models in SQL Server 2016 Preview
- What's New in Microsoft SQL Server Analysis Services Tabular models in SQL Server 2016 CTP 2.3
- Data mining and Power Pivot for Excel 2010 add-in issues with Windows 10 and Visual Studio 2015
- DAX now has variable support!