Overview
Data types and operators are basic units of storage and navigation in any functional / programming language. DAX also contains a small set of data types and operators. In this chapter we will briefly list all the data types and operators available in DAX.
Explanation
Below is a list of data types and operators available in DAX.
Data Types in DAX
- Whole Number – Positive or negative integers with no decimal places.
- Decimal Number – Real numbers are numbers that can have decimal places up to 17 decimal digits.
- Boolean – Either a True or False value.
- Text – A Unicode character data string. Can be strings, numbers or dates represented in a text format.
- Date – Dates and times in an accepted date-time representation. Valid dates are all dates after March 1, 1900.
- Currency – Currency data type allows values with four decimal digits of fixed precision.
- Blank – A blank is a data type in DAX that represents nulls.
Operators in DAX
- Comparison operators (=, <>, <, <=, >, >=) – To compare values and return a logical TRUE/FALSE value.
- Arithmetic operators (+, -, *, /) – To perform arithmetic calculations that return numeric values.
- Text concatenation operators ( & ) – To join two or more text strings.
- Logical operators (&&, ||) – To combine two or more expressions to return a single result.
Siddharth has more than 14 years of experience in the IT Industry, with more than a decade of experience in Business Intelligence and Analytics, for clients banking, logistics, government, Media Entertainment, products, life sciences and other domains. He has been a lead architect for a portfolio of 40+ apps, containing apps in web, mobile, BI, Analytics, data warehousing, reporting, collaboration, CMS, NoSQL and other technologies. He has several certifications and is a published author for online and print-media publications, as well as the MSDN Library.
In his present role, he remains responsible for architecture design, technology stack selection, infrastructure design, 3rd party products evaluation and procurement, and performance engineering. These applications use technologies like Elasticsearch / Lucene, MongoDB, SharePoint 2013 and 2010, jQuery-based framework like Highcharts and GoJS, SQL Server and the Microsoft Business Intelligence stack (SSIS, SSAS, SSRS, MDX, PowerPivot, PowerView), jQueryMobile, Bootstrap, iOS xCode framework, and many others.
- MSSQLTips Awards: Champion (100+ tips) – 2018 | Author of the Year – 2017 | Author Contender – 2016, 2018-2019
