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

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 I am going to show you how you can optimize a simple measure involving CROSSJOIN and in the process we are also going to...

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

In this blog let’s understand why you should use KEEPFITLERS more often. Below is the snapshot of the data model ( Contoso Retail Data...

Context transition — one of the most complex topics to understand and master but have you ever wondered, what actually happens behind the...

Creating a Running Total is pretty simple in DAX, you just take a measure, wrap it inside CALCULATE and then with the help of DATESYTD...