fbpx
Skip to content
DataChant
Menu
  • Shop
    • All Products
  • Book
    • Book Q&A
    • Excerpts & Extras
  • Subscribe
  • About
    • About Gil
    • Subscriber’s Corner
    • Archived Gallery
  • Power BI Apps on AppSource
    • Mailchimp
    • ActiveCampaign
    • ActiveCampaign PBIX Instructions
    • Dataflows Snapshot Analysis
    • Power Apps Dataflows Snapshot Analysis
    • Excel Compare
    • Twitter Dashboard
  • Shop
    • All Products
  • Book
    • Book Q&A
    • Excerpts & Extras
  • Subscribe
  • About
    • About Gil
    • Subscriber’s Corner
    • Archived Gallery
  • Power BI Apps on AppSource
    • Mailchimp
    • ActiveCampaign
    • ActiveCampaign PBIX Instructions
    • Dataflows Snapshot Analysis
    • Power Apps Dataflows Snapshot Analysis
    • Excel Compare
    • Twitter Dashboard

Tag: PivotTable

Power Query

Transform ANY nested table to Pivot Table with function query

Gil RavivJanuary 3, 20163
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...
Power Query

Transform a nested table to PivotTable

Gil RavivJanuary 3, 20160
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...
Power Query

Back to School – Transform class schedule to PivotTable

Gil RavivJanuary 3, 20162
Back to school with Excel & Power Query This is the second post in the series The Definitive Guide to Unpivot with Power Query in Excel. For today's post...
Excel for Security Analysts

Excel for Security Analysts – Intro

Gil RavivJanuary 3, 20160
(Originally published here) The demo I will share with you today is something that I was itching to try for a while. Before I joined Microsoft and Excel team,...

Write a Review

Install our Power BI Apps on AppSource

Tags

#MSDataSummit AppSource Bad Practices Bonus Exercise Book COVID-19 Custom Visuals Data Quality Automation DAX Excel Excel 2016 Facebook Facebook bug Facebook Insights Facebook Reactions Get & Transform Jedi List.Accumulate List.Generate Logs MailChimp Microsoft Cognitive Services Multiline records MVP Pitfalls PivotTable Power BI Power BI Governance Power Pivot Power Query Power Query Book Robust Queries Sentiment Analysis Star Wars Subscribers Tableau vs Power BI Template Apps Text Analytics Twitter Analytics Unpivot Update US Election Candidates US Presidential Candidates Webinar Web Scraping

Blog Stats

  • 1,401,166 Views
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Privacy Policy
  • Home
  • Shop
  • Book
  • About

Copyright 2021 DataChant Consulting LLC All Rights Reserved

 

Loading Comments...