Next Steps
Now that you know the basics of using DAX to query a tabular model, please do the following:
Please refer to my pervious tips to understand how tabular model can be created:
- Create Tabular Model Sample from SQL Server Database – Part 1
- Create Tabular Model Sample from SQL Server Database – Part 2
Check out these other tutorials:
From SQL Database sample try the following:
- Create and populate the Supplier table in the sample database and import it into the tabular model and link it to the Product to write slightly more complex DAX queries.
- Try to write the equivalent T-SQL queries for some of the DAX queries mentioned in this tutorial against the SQL database to understand the ease and comfort of DAXing data vs Querying data.
- Try creating some Calculated Columns in your tabular model using your DAXing data knowledge.
Haroon Ashraf’s deep interest in logic and reasoning at an early age of his academic career paved his path to become a data professional.
He holds BSc (Gold Medal) and MSc Degrees in Computer Science and also received the OPF merit award.
His programming career began in 2006 working on his first data venture to migrate and rewrite a public sector database driven examination system from IBM AS400 (DB2) to SQL Server 2000 using VB 6.0 and Classic ASP along with developing reports and archiving many years of data.
His work and interest revolves around Business Intelligence and Database Centric Architectures and his expertise include database and reports design, development, testing, implementation and migration.
He has recently earned “Knowledge Management and Big Data in Business” certificate from The Polytechnic University of Hong Kong.
- MSSQLTips Awards: Trendsetter (25+ tips) – 2020 | Author of the Year Contender – 2018-2020
