Tag: advanced editor power query

Power BI Values And Literals – Understanding The Basics

Introducing-Values

In this tutorial, you’ll learn about Power BI Values and how they are generated inside the Power Query Editor. These values have corresponding literals that can be used in codes and expressions to produce results and data. You’ll also learn how and where to apply the values to build a compelling report. Power BI Values

Continue reading

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 can 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