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