Download File:
Start File: https://excelisfun.net/files/EMT1438-1439Start.xlsx
Finished File: https://excelisfun.net/files/EMT1438-1439Finished.xlsx
Entire page with all Excel Files for All Videos: https://excelisfun.net/
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.
Related Videos:
Excel Magic Trick 1439: DAX Formula to Create Cross Tabulated OR & AND Logical Test Sales Total
Excel Magic Trick 1438: Excel Formula to Create Cross Tabulated OR & AND Logical Test Sales Total