Author Archives: Ansh Purohit

Creating Histogram in Power BI – Method 1

Hello all,In this series of blog posts, we will look into 2 different ways to create a histogram (bins) in Power BI. Let us first talk about the data that we will be using for this post. The sample data can be downloaded here. Our sample data contains columns such as employee ID, sale amount,Continue reading “Creating Histogram in Power BI – Method 1”

Demystifying Date Dimension Part 4

Let us pick up where we left off. In part 3 we created a date table but in a very brute force method. Let us make this more dynamic in this series. If you followed me every step of the way you should already have this in your table. If not then just click onContinue reading “Demystifying Date Dimension Part 4”

Demystifying Date Dimension Part 3

Hello All, Let us take a deep dive into another way of creating the Date Table. However, for the next few series of blog posts, we will focus on M Query and we will first work with static values and then modify the M Query to make it more dynamic. Steps that you can followContinue reading “Demystifying Date Dimension Part 3”

Power BI Date Dimension Demystified Part 2

Hello All, Let us continue with our journey of demystifying the Date Table. In my last post, we learned to use CALENDARAUTO() function. We will continue today with the second DAX function called Calendar(). We will also look at how to extract other “relevant columns” such as year, month name, month number, etc. I willContinue reading “Power BI Date Dimension Demystified Part 2”

Power BI Date Dimension Demystified Part 1

Hello All, Today let us take the first step towards demystifying Date Table journey. Date Dimension plays a very important role. Almost always there is a need to perform and derive time-based insights. Few ground rules must be adhered to when it comes to creating a robust date table. These are The date table must contain uniqueContinue reading “Power BI Date Dimension Demystified Part 1”

Introduction

The big question: What exactly is Power BI? Short answer: A data visualization tool. Long answer: Though primarily it is a data visualization tool, Power BI is a very powerful self service BI tool. It is made up of multiple components and they all work in tandem to provide you with a wholesome data discoveryContinue reading “Introduction”

Custom Scripts – Power Shell

One of my close friend had this discussion with me about how to get list of workspaces with certain conditions and how to get those details using PowerShell script. So this following script was written to get conditional workspaces and displaying them. While we were testing this, we realized that there was an error thrownContinue reading “Custom Scripts – Power Shell”