Welcome back to our Power Pivot blog. Today, we look at using concatenation with the FILTER function to combine filter criteria.

Welcome back to our Power Pivot blog. Today, we discuss the IN function, one of the several logical functions in Power Pivot.

Welcome back to our Power Pivot blog. Today, we introduce the DATEADD function.

Welcome back to our Power Pivot blog. Today, we go over the DAX syntax naming requirements and conventions when it comes to tables, columns and measures.

Welcome back to our Power Pivot blog. Today, we go over when to use fully qualified names.

Welcome back to our Power Pivot blog. Today, we discuss factors to consider when creating and using Calculated Columns.

Welcome back to our Power Pivot blog. Today, we discuss how to create and use Perspectives in PowerPivot.

Welcome back to our Power Pivot blog. Today, we discuss some tips and best practices you should keep in mind when working with Calculated columns.

Welcome back to our Power Pivot blog. Today, we discuss why it is important to have Contiguous Dates in a calendar table.

Welcome back to our Power Pivot blog. Today, we introduce the CLOSINGBALANCEMONTH function.