Excel Magic Trick 1439

DAX Measures to Create Cross Tabulated OR & AND Logical Test Sales Total

DESCRIPTION

Using Excel 2016, see how to use a DAX Formula with CALCULATE Function, the SUM Function and the IN Operator to create two formulas for adding sales based on Product Groups. This example will work in any version of Excel 2016, even if you do not have Power Pivot. Learn how to create a Cross Tabulated Table to add Sales with Sales Channel Criteria as the Row Header Criteria and Product Group OR Criteria as the Column Header Criteria. See the final Report created with a Data Model Pivot Table. This formula works in both Power BI Desktop and Excel Power Pivot.

WORKBOOKS

Download “Excel Magic Trick 1436-1440” Excel-Magic-Trick-1436-1440.zip – Downloaded 62 times – 81 MB




Be the first to comment

Leave a Reply