power query

power query

962 bookmarks
Custom sorting
Part 2: Combination of rows of tables list in Power Query
Part 2: Combination of rows of tables list in Power Query
Part 1 describes approach showing how to work with List.Generate, Table.FromRecords, List CrossJoin in Get & Transform (aka Power Query, M language). Homework is done. Advice is digested. And I…
·bondarenkoivan.wordpress.com·
Part 2: Combination of rows of tables list in Power Query
Combination of rows of tables list in Power Query
Combination of rows of tables list in Power Query
Recently I faced interesting Power Query problem. Actually, initial problem has nothing related to Power Query. I required to export quite big volume of data from SAP BW using Business Objects Anal…
·bondarenkoivan.wordpress.com·
Combination of rows of tables list in Power Query
Unfold Child-Parent hierarchy in Power Query
Unfold Child-Parent hierarchy in Power Query
In this post I consider two types of hierarchies First table defines typical hierarchy of companies. Usually, such hierarchy is used for financial reports to group key figures. Most probably, we kn…
·bondarenkoivan.wordpress.com·
Unfold Child-Parent hierarchy in Power Query
Displaying Help For A Power Query Function
Displaying Help For A Power Query Function
Matt Masson and Theresa Palmer gave an excellent presentation on Power Query and M for the PASS DW/BI Virtual Chapter a few days ago (hopefully it will be on their YouTube channel soon). One thing …
·blog.crossjoin.co.uk·
Displaying Help For A Power Query Function
Comparing Columns In Power Query
Comparing Columns In Power Query
A few weeks ago I wrote a post about comparing the contents of entire tables in Power Query, and a question came up in the comments about how you might go about comparing values in columns rather t…
·blog.crossjoin.co.uk·
Comparing Columns In Power Query
Building Relative Date Reports in PowerPivot
Building Relative Date Reports in PowerPivot
It’s a very common requirement when you’re building a report in PowerPivot (or indeed in any BI tool) for it to automatically show data for today’s date, the current week or month (plus maybe a set…
·blog.crossjoin.co.uk·
Building Relative Date Reports in PowerPivot
Power Query: Allowed values
Power Query: Allowed values
How slow is a bit slow? How many rows are there in each table, and what type of data source are you using? I was wondering if a more 'relational' appr
·mrexcel.com·
Power Query: Allowed values
Solved: Refreshing queries with functions doens't work - Microsoft Power BI Community
Solved: Refreshing queries with functions doens't work - Microsoft Power BI Community
Does anyone else experience that refreshing on-premise data via a gateway (for example amount of files in a folder) works if you hardcode the path to the folder, but when you create a function where the path is the input parameter powerbi says that you are not able to refresh this data source?
·community.powerbi.com·
Solved: Refreshing queries with functions doens't work - Microsoft Power BI Community
Load Power Query function from GitHub
Load Power Query function from GitHub
Why scenario of “Loading Power Query function from GitHub” is interesting? Assume that you work in big company, or small, doesn’t matter. You and your colleagues use shared librar…
·bondarenkoivan.wordpress.com·
Load Power Query function from GitHub
Transform ANY nested table to Pivot Table with function query - DataChant
Transform ANY nested table to Pivot Table with function query - DataChant
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 Query technology, the Unpivot transformation is available for everyone using the new Get …
·datachant.com·
Transform ANY nested table to Pivot Table with function query - DataChant
Power Query List.Accumulate – Unleashed
Power Query List.Accumulate – Unleashed
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 me: [crayon-59aec6d1333d2775222960/] Argument Description list The List to check. seed The initial value seed. accumulator The value accumulator function. OK. I understood the list argument quite right, but the other two arguments were post-nuclear-bomb science fiction. So let’s …
·datachant.com·
Power Query List.Accumulate – Unleashed