DAX CALCULATE Function

If you'd like to "see" how the DAX CALCULATE function works, then you need this tutorial. It will show you what's happening behind the scenes: How the CALCULATE function works and delivers results.

3 Hidden Tips for Power Pivot

These 3 hidden Excel Power Pivot tips will help you to: Copy your data model from one file to another, create a dedicated measures table and convert your pivot table data to formulas.