Knowing how to use Lists in Power Query or Power BI is like a superpower. This Post will show you how to filter a Table to a Dynamic List of Values by using Lists in ...
In Slovenia (where I come from) there is a significant shortage of Excel and Power BI conferences. Basically, there are none (I’m planning to change that in ...
I’ve always been a big fan of the Import from Folder feature in Power Query. So much so, that I wrote my first post on the topic way back in February of 2015. ...
This weeks post will be a short testament to a development venture by a few of my countrymen. Like most of Excel fans, I’m also a big fan of Power BI and ...
I guess every data professional that has ever taken on the challenge of creating data models either in Power Pivot or in Power BI knows the importance of the ...
The other day I made a Dashboard with a classic by time and relevant dimensions analysis. The data was pulled from Azure SQL DB, so Power Query was the method I ...
The following post was written as the reply to a great question Dane asked in the Comments section of the Power Query’s Unpivot Function post I wrote back in ...
I recently posted on how to make a process of getting data from a folder bulletproof. You can read it here. Whereas that post was about getting data from multiple ...
The title of this post is stolen from the legendary Bob Dylan song, but rightfully so since it’s one of the biggest game changers in the Power BI game (and ...
This article will show you how you can use that nobody’s child called Power Map or 3D Map to solve a problem many of us wish to run into one day. We get ...
This article will take care of the most fundamental need when it comes to Power Pivot or even Power BI and Time Intelligence. Having a Date Table (Calendar Table) is ...
Following a wide demand, I also wrote a post about getting data from Excel files in a folder. You can read it here and I recently followed up with a post on how to ...
Probably the longest title of all times, but it leads to something great. First let’s explain Power Query. Power Query is an AddInn for Excel and part of ...
If some pictures are hard to view, you can get the PDF of the article The Pivot option in Power Query. With the latest update of Power Query AddInn for Excel quite a ...
One might think that analyzing data with a Pivot table is hard, but Unpivot a Pivot table proves to be even harder. But Power Query or better yet a Query editor ...
This question or rather comparison never seizes to amaze me, since it’s just like comparing Eric Clapton to a Ford Mustang. It just can’t be done since ...
This is the second article of three. If you hadn’t read the first part yet, it is recommended that you do so. It talked about the basics of PowerPivot and ...
10 things you need to know The following article is kind of a baseline knowledge, one should possess, before attempting the creation of their first PowerPivot ...
Hands down, YES! If you would like to read about the comparison of definitions of the two, you can do so in the Pivot Table vs Power Pivot post. If you are new to ...
Here is our “problem”. When you create a Pivot Table in Excel that has a date field and is based on data in Excel, you can Group that field by month and ...