Tag: advanced editor power query

Extract Values From Records And Lists In Power Query

Extract Values From Records And Lists In Power Query

In this blog post, we’ll take a look at how you can extract values from records and lists using power query. As you can see, the first column in my table contains records. You may watch the full video of this tutorial at the bottom of this blog. When I click off to the side

Continue reading

Combinatorial Analysis Using Power Query In Power BI

Combinatorial-Analysis-Using-Power-Query-In-Power-BI

I want to do a deep dive into something called combinatorial analysis. This can be defined as the choosing and arranging of elements of sets in accordance with prescribed rules. It might sound esoteric, but it’s actually got some very practical use cases. You may watch the full video of this tutorial at the bottom

Continue reading

Power Query M: Alternating 0-1 Pattern In Date Table

Power-Query-M-Alternating-0-1-Pattern-In-Date-Table

This tutorial focuses on using the Power Query M number.mod function to create an alternating 0-1 pattern in the Date table. The solution that I’m going to show you came from one of our community power users, Rajesh, at Enterprise DNA. You may watch the full video of this tutorial at the bottom of this blog.

Continue reading

Show Last Refresh Date/Time In Your Power BI Reports

Show-Last-Refresh-DateTime-In-Your-Power-BI-Reports

In today’s blog post, I’m going to show you a tip on how I create a last refresh date and time so that I can show it on all of my Power BI reports. You may watch the full video of this tutorial at the bottom of this blog. Most of my clients say that

Continue reading

Power BI Query Editor: Row & Column Transformations

Power BI Query Editor Row and Column Transformations

In this tutorial, we’ll discuss essential transformations within Power BI Query Editor that can be used to optimize your rows and columns. In developing an intuitive Power BI model, it’s best to simplify your rows and columns inside your table. Optimizing your table is essential in creating visualizations, so you can easily recognize your data.

Continue reading