Power BI

This post continues series of articles about M Function List.Zip ( first post, second post). Table.T...

Ever looked at a Power BI report visual and wondered what the logic was behind a calculation? In mos...

Here’s a really common problem that occurs when combining data from multiple files, or indeed any ty...

If you want to quickly create a list with all dates (or specific intervals) between 2 dates, this function is for you: Date.DatesBetween

One of my favourite features in Excel and Power BI is Power Query / M – and I just wanted to share a small trick when you want to filter a table on specific items. Let’s imagine you want to f…

I am excited to share with you an excerpt from the draft manuscript of my book. You can also add it to your list in Amazon here. I expect to publish more excerpts in the coming months, so please stay tuned, and subscribe to DataChant. Appending Worksheets from a Workbook Excerpted from the draft manuscript …

A new, as-yet undocumented, M function appeared in the December 2017 release of Power BI Desktop (I assume it will appear in Excel soon): Text.Select. Here’s the documentation from the Query Editor…

Hello Everyone! In this episode of the “Problem, Design, Solution” series we will be talking about the “Folder” option inside the sources display for Power BI Desktop. This is a fantastic feature …

The Query Editor in Power BI/Excel Get&Transform/Power Query has a number of built-in ways to filter data in date columns relative to the current date, such as the “In the Previous” option. How…

Hello P3 World! My name is Krissy Dyess and I have had the most amazing experience working as a full-time consultant at Power Pivot Pro since April 17, 201

My new function Text.RemoveRepeatingCharacters cleans up badly formatted text where spaces or other separators are applied multiple times.

Let's take a deep dive into understanding how the each keyword in Power Query, which is used by quite a few of the built-in operations (filtering, custom columns, etc.).

This post shows how to write documentations for custom functions in M for Power Query for Excel and Power BI Desktop, by modifying metadata.

Visual Studio 2017 and the SQL Server Data Tool (SSDT), a tool that comes with Visual Studio, finally integrates the now familiar Query Editor (Power Query) capability to work with the Analysis Ser…

Table.Group in Power BI and Power Query has a very powerful 5th parameter that's worth checking out. Case insensitive grouping is just one cool feature.

Selecting items from lists is often used for cleaning text-fields. List.SelectPositions allows you to select them by addressing their positions in Power Que

I was playing around with a scenario this morning where I was adding try results together in order to count how many columns were filled with information. What I needed to do kind of surprised me a little bit.

The nice people at PASS have made a video of my session on “Using SSAS MD as a data source for Power BI” available to view for free on YouTube: I’m honoured that it’s listed…

It may not be immediately obvious, but you cannot set your own connection string properties when connecting to SQL Server using the built-in SQL Server connector from either Power BI or a modern da…

I recently had a requirement from a customer who needed to filter reports based on global option sets. The kicker for this requirement was t...

I found this and it works: let Source = Sql.Database("DB_SERVER", "DB_NAME", [Query="exec STORED_PROCEDURE_NAME'"&Date.ToText(Date.From(DateFrom), "yyyy-MM-dd")&"', '"&Date.ToText(Date.From(DateTo), "yyyy-MM-dd")&"' , 62", HierarchicalNavigation=true]) in Source And it works! Thank you guys

One of the challenges I had working with a client recently was around how to work with ranges/bands of numbers in Power BI so thought I’d share the approach I took to this. I was looking to deal with …

I did it in one table instead of creating new table for each character's id. We need one table and one function. Here's full solution: 1. Create function getCharacter(id): let Source = (id as text) = let Source = Json.Document(Web.Contents("https://swapi.co/api/people/" & id))...