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

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

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

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

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

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

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

Power BI allows you to create reports easily by bringing columns from multiple tables or from a single table and by putting those columns...

PARALLELPERIOD is a DAX function that allows you to shift MONTH, QUARTER, or YEAR based on the the dates visible in the filter context,...

RLS or Row Level Security allows admins to restrict the data access for a particular user. You can define RLS only in Power BI Desktop...

Extracting numbers from an alphanumeric string like "b52h1l1h8gyv3kb7qi3" and then summing or just concatenating those values is really...

What's the best way to create color schemes/themes for your Next Power BI report? Let's see that today! Credits - I learned this trick...

Creating running totals on a numeric or date field is pretty easy because you always have something that you can use to compare against...

One of a very common requirement that I have seen is to be able to filter out the selection made in the slicer from a visual such as a...

Wouldn’t it be awesome if we could sneak peak the code of a measure A when we are writing a different measure B and calling measure A...

Effective March update of Power BI you can specify different columns in the single filter argument of CALCULATE without writing the...

If there is one thing every DAX developer has ever dreamt about is to be able to view the filter context inside Power BI to debug DAX...