Convert Power Pivot to Formulas


March 30, 2023 - by Bill Jelen

Convert Power Pivot to Formulas

continue reading »

More Reading


Unapply a Filter Using DAX

Unapply a Filter Using DAX »

March 28, 2023 - by Bill Jelen


With SUMIFS, you go through a data set, finding rows that match all of the criteria. With CALCULATE, you go through a data set, calculating values that match the filters in CALCULATE.

Calculate() is Like SUMIFS()

Calculate() is Like SUMIFS() »

March 27, 2023 - by Bill Jelen


As you get started with DAX, you are going to find yourself using the CALCULATE function. This function will perform a calculation while applying any number of filters. =CALCULATE(Sum(Field),Filter1, Filter2, Filter3).

Replace Calculated Fields with DAX

Replace Calculated Fields with DAX »

March 24, 2023 - by Bill Jelen


The DAX formula language really shines when you use it to create a new measure for your pivot table. DAX measures are in the same genre as calculated fields, but are infinitely more powerful.

read more articles »

Featured Products


MrExcel 2022 Boosting Excel

April 2022

The 6th Edition of MrExcel XL, updated with new functions released for Microsoft 365.


Microsoft 365 Excel: The Only App That Matters

June 2022

Excel Worksheet, Power Query, Power Pivot, Power BI. Calculations, Analytics, Modeling, Data Analysis and Dashboard Reporting for the New Era of Dynamic Data Driven Decision Making & Insight!


Microsoft Excel Pivot Table Data Crunching (Office 2021 and Microsoft 365)

December 2021

Use Microsoft 365 Excel and Excel 2021 pivot tables and pivot charts to produce powerful, dynamic reports in minutes: take control of your data and your business!


Microsoft Excel VBA and Macros (Office 2021 and Microsoft 365)

April 2022

Use this guide to automate virtually any routine Excel task: save yourself hours, days, maybe even weeks. Make Excel do things you thought were impossible, discover macro techniques you won't find anywhere else, and create automated reports that are amazingly powerful.


see more products »