fbpx
Skip to content
DataChant
Menu
  • Book
    • Book Q&A
    • Excerpts & Extras
  • 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
  • Book
    • Book Q&A
    • Excerpts & Extras
  • 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: List.Accumulate

Automatically remove empty columns and rows from a table in Power BI

Maya RavivJuly 21, 20211
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...
Book

Book Excerpt: Loops, Recursions, Fibonacci and more from Chapter 9: M #PowerQuery

Gil RavivApril 9, 20188
The draft of my book is almost ready (I even have few Excel formulas that are showing me, that I have already wrote 93% of the books, and a total of 359 draft...
CamelCase in M

Split CamelCase headers in M (And a fix for the Record of Promises)

Gil RavivFebruary 14, 201818
How many times did you have to work with tables that had headers like these? Client_ID, Transaction_ID, Product_Name,...
Remove empty columns and rows from a table in Excel

Automatically remove empty columns and rows from a table in Excel using Power Query

Gil RavivDecember 9, 201621
In today's tutorial, we will solve a very common challenge in Excel. You start with an Excel table and you wish to condense it by removing all the columns...
List.Accumulate Unleashed in Power Query and Get & Transform in Excel and Power BI Popular

Power Query List.Accumulate – Unleashed

Gil RavivJune 2, 201610
Following a reader's request, today we will unleash the power of List.Accumulate. The official documentation on List.Accumulate here was very confusing for...

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,543,207 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...