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

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

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

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

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