Excel Magic Trick 1439

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


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.


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

Be the first to comment

Leave a Reply