Excel Magic Trick 1437: DAX Query OR Logical Test IN Operator: Pull Sales Team Data to Excel Sheet HD

Download File: Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1437Start.xlsx Finished File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1437Finished.xlsx Entire page with all Excel Files for All Videos: http://people.highline.edu/mgirvin/excelisfun.htm See how to build a DAX Query OR Logical Test using the IN Operator to Pull Sales Team Data to an Excel Sheet from the Power Pivot Data Model. See the DAX Functions: CALCULATETABLE and VALUES. Use DAX Studio to build the DAX Query and then use Excel’s Existing Connections, Edit DAX Feature to connect to the Data Model and pull data to an Excel Sheet.