Objects tagged with power-query


Posts

← Back to the Posts

Excel IFERROR in Power Query M or Power BI

Published on September 02, 2021 at 11:39PM

if `try otherwise` not remembered then read this or else just `IFERROR`

[SOLVED] Excel ISNULL, ISBLANK type custom function in Power Query M

Published on September 02, 2021 at 11:11PM

I call this function `ISPRESENT` to test for values that are not null, empty strings/blanks or zeros.

Power Query M function to add days to a date

Published on September 02, 2021 at 11:09AM

You have a parameter like `today` and you want to easily add and substrate days from that... like yesterday is `days_ago(1)`

Power Query M Blank Function Template

Published on September 02, 2021 at 11:00AM

Slap in that 1+1 = 2 blank function template so you don't have to do all the syntaxes

[SOLVED] First Day of Last Month in Power Query M

Published on July 29, 2021 at 06:10AM

Today is the 29th of July 2021... this Power Query M returns 1st of June 2021 like `1/06/2021`

Blank Power Query Template for a Raw SQL Query using Microsoft SQL Server

Published on May 24, 2021 at 03:57AM

You want to send raw sql from Power Query to your SQL Server database so you can do better query folding than Excel.

Return Database Schema for Table Using Power Query

Published on January 29, 2021 at 01:12AM

Point this query to your database table and return all columns and schema meta data using Power Query in Excel

Add Text to an Existing Column in Power Query

Published on November 16, 2020 at 04:10AM

Add some text or value to an existing column of values. Example like adding "ABC" to the start of all values in a [Name] column

Power Query - Left Pad an SAP Product Hierarchy with Zero

Published on August 19, 2020 at 01:10AM

Convert SAP Product Hierarchy that has been broken by Excel `1010101` back into `01010101`

Extract Multiple Product Hierarchy Levels from an SAP Product Hierarchy Key

Published on August 19, 2020 at 01:02AM

SAP Product Hierarchy 0101010101 maps to Level 1 **01**, Level 2 **0101**, Level 3 **010101** Level 4 **01010101** and Level 5 **01010101**

Blank Power Query Template for a Raw SQL Query

Published on June 15, 2020 at 01:23AM

You want to send raw sql from Power Query to your database because you're better at query folding than Excel.

Removing Leading Zeros from Alphanumberic Strings using Power Query M

Published on June 09, 2020 at 09:36AM

You probably extract data from SAP that looks like '000ABC1234' and you want to remove the '000'

Remove Leading Zeros from Strings using Power Query M

Published on June 09, 2020 at 09:35AM

You have a string like '000123456' and you want to remove the zeros and make it '123456'

Create an Empty Table with Explicit Types in Power Query M

Published on June 09, 2020 at 09:32AM

Who'd a thought Explicit Types in an Empty Table would be so fulfilling... :/

[SOLVED] Today's Date in Power Query M

Published on June 04, 2020 at 03:55AM

Just copy `Date.From(DateTime.LocalNow())` <= this if you don't even want to visit my website XD

A Simple Worksheet Parameter Pattern for Power Query

Published on February 26, 2020 at 04:17AM

How cool would it be to call a value from an Excel Worksheet from within a Power Query using a simple variable definition?

Cross Join in Power Query to Combine Two Tables with Every Combination

Published on September 13, 2019 at 04:06AM

When you want 'red,green' and '1,2' to become 'red1,red2,green1,green2' use a cross join!!

Using VS Code Extension MSSQL instead of Excel Power Query for Easy Database Querying

Published on February 07, 2018 at 12:01AM

Save a few minutes every time you want to query your database to check out some data by cutting Excel out of the equation.

Add Hyperlinks to an Entire Column using VBA in Excel

Published on February 05, 2018 at 04:50AM

Convert Salesforce id and name to clickable hyperlinks in an Excel table after extracting data from Power Query

Create a Simple Empty Table in Power Query with Code Example

Published on December 14, 2017 at 06:23AM

Just copy and paste this into a blank query and you will get a simple two column table with two rows.

Add a Date Model to PowerBI or Power Query

Published on December 08, 2017 at 12:10AM

I regularly add a model to my Power BI or Power Query to represent the date and functions around date.

Writing a Blog Post About M Lang/M Language/Power Query Formula Language/Power BI/Get & Transform

Published on June 21, 2017 at 12:51AM

Informally Known As WTF is M

Simple Power Query M to Display When the Report was Last Refreshed

Published on May 17, 2017 at 12:39AM

Very simple query to show when you last hit the 'Refresh' button in PowerBI

Creating an Atom Grammar Language Package for M Power Query Formula Language

Published on March 23, 2017 at 06:16AM

I was sick of using Atom for Power Query without auto completion or syntax highlighting so I'm building an Atom Grammar package for M

The Microsoft Mashup Evaluation Container is a CPU and RAM hog

Published on March 22, 2017 at 11:35PM

Investigating why Power Query is using so much RAM and CPU and what I can do about this

Tiny Tweaks Needed for the Power Query Editor

Published on March 20, 2017 at 12:33AM

A collection of the issues I run into day to day using the Query Editor along with the magic sauce to make it better

Implementing an Environment Parameter in Power BI to Improve Performance in Development

Published on March 06, 2017 at 06:18AM

Limit the amount of time you watch Power BI getting rows of data when you are working on your views

Managing Queries in PowerBI and Power Query using Git

Published on March 01, 2017 at 12:54AM

Backing up and using version control systems are real things we should consider to save us from that next crash that is likely to occur

Add a DateKey Column in PowerBI M Lang

Published on February 21, 2017 at 01:18AM

Date's can get difficult to merge on other date or datetime fields. Use this function to convert to a DateKey or Date ID

Loading M Queries from the Web into Power BI

Published on February 15, 2017 at 04:08AM

Reuse your code by pulling queries from web servers

Single and Multi Line Comments in Power Query Advanced Editor

Published on February 13, 2017 at 11:01AM

Just a simple reminder on how to do single and multiple line comments

Countif in Power Query or Powerbi using M Language

Published on February 13, 2017 at 10:57AM

You know how to countif in Excel so why is Power Query so difficult?

Screencasts

← Back to the Screenasts
There are no casts tagged with power-query