If you work with Power BI and SSAS Tabular one thing to know is that there are 2 engines in Analysis Services i.e. Formula & Storage...

In this blog let's take a look at the performance of a report when you use a Measure in the Filter Pane. Let's say you have a data model...

Recently I faced a situation where a simple measure such as COUNTROWS was returning a blank, yeah what's up with that? COUNTROWS...

DAX language of Power BI and SSAS Tabular doesn't have a function for Full Outer Join so in this blog we are going to see a work around...

In this article let's take a look at how to get started with aggregations feature in Power BI. I will try to explain aggregations in a...

In this blog let's take a look at how you can use Python to connect to either Power BI or SQL Server Analysis Services to run DAX...

Last year we released a course on one of the most famous development tool for Power BI, check out the interview I had with EDNA.

Recently someone asked a question that whether they should store a column in a Tabular model in String or Integer format and in this...

Have you ever writen a piece of DAX Code that looks like this: and ended up confused how is it able to calculate how many years, days,...

In this blog lets see how we can implement OLS or Object Level Security in Power BI. In simple terms the difference between RLS and OLS...

Having a complete date table in your SSAS model is extremely important, a complete Date table helps in ensuring that the time...

A very common scenario in Power BI is of extracting measure into text file and then loading them back again in the Power BI file so that...

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