TE3 is the ultimate development tool for creating Tabular Model and recently I got an opportunity to make a full fledged course on it for...

In this blog let's see how we can combine Stored Procedure and Parameters to load data into PBI. First we need to create a very basic...

SUM and SUMX are both aggregation functions in DAX. While SUM allows you to aggregate only one Physical column of a table, SUMX is more...

I am always amazed by the capabilities of Tableau to create visuals that are difficult to create in different tools such as Power BI. In...

Recently participated in the Onyx Ecommerce challenge on LinkedIn and made this dashboard, nothing too fancy it is just something I made...

One of the most common time intelligence calculations that I see in each report is that of Previous Year, this calculation is pretty easy...

Whenever I work with LinkedIn data challenges a very common task for me is to load data into SQL Server as modifying the data in SQL is...

Tried to replicate Andy Kriebel's Sales Dashboard in Excel. Link to Tableau viz - https://public.tableau.com/app/profile/andy.kriebel/viz...

In this tutorial lets see how easy it is to create a running total in DAX either in SSAS, Power Pivot or Power BI. Running total is a...

In this tutorial lets see how you can use XLOOKUP in Excel to find the postion of the Lookup Value in the Lookup Array. Doing this with...

In this tutorial lets see how we can SUM cells in Excel with similar colors with the help of VBA. The dataset we are going to use: Now go...

I was recently working with a dataset and found that there were a lot of columns that were completely null, now going 1 by 1 through each...

One of the very common requirement of Power BI users is that of showing only those measures in a visual which are selected in a slicer....

Creating relationships in Power BI is as simple as it can get but to be able to edit/create relationships in Power BI with TE is...

In Power Query if you want to change names of columns you can easily do so by going through each column one by one and then renaming...

Out of the box TE doesn't allows you to create Calculated Table in Power BI, but if you want you can easily do that. To be able to create...

In this blog I am going to show you how you can optimize a simple measure involving CROSSJOIN and in the process we are also going to...

VBA allows you to create sub-routines or functions that can be hidden from the end user using only Excel interface, but sometimes that...

In this blog let's see how to compute value of the measure for every other value of a column except for the one that is currently visible...

ADDCOLUMNS is a DAX table function that allows user to add new columns to the existing data. It has 3 main Arguments Table - The table on...

Website: https://www.antmanbi.com/ YouTube: https://www.youtube.com/channel/UCDnIr1sOkcguc_h30XWCAaw/videos LinkedIn:...

In this blog let's understand the difference between selecting columns in SQL vs DAX, i am using a fairly simple Product table which...

In this article let's understand what Circular Dependency is and how it can cause issues when creating Calculated Columns in a Fact table...

In this blog I am going to show you how you can remove unwanted characters all at once from an improper text string like the following...