When heavy Excel users start learning DAX, they often ask me?
” We have so many and powerful Excel formulas and Pivot Table too, which can do all of what DAX can, why do we need to learn DAX? ”
Good question..
Although I do answer that question but for today, let’s play a game..
“Excel versus DAX“
The Game
- I am going to give you a simple data and 3 questions that follow, that you’ll have to solve using Excel formulas or Pivot Tables.
- I’ll also give you the expected answers that you should come up with using Excel.
- Finally post your answers (link to the file) in the comments
Consider 2 tables
Sales Data, the columns are self explanatory.
And the Product Table where the ProductID is unique.
Solve these 3 Questions
- How many unique Bikes were sold each month with Price >= $ 1,000.
- How many $100k days are there each month. (i.e. Sale value in a single day >= $ 100,000)
- Total Sales and Total Sales Shipped each month
Answers in the comments
To all folks who participate (irrespective of the answers) and leave a comment with their work, I’ll give them a shout in the “Answers Session”. Come on fellas, let’s get this going!
Solutions Video
DOWNLOAD SOLUTIONS FROM BELOW
