• Skip to main content
  • Skip to footer

Curbal

Learn how to grow your business with your data and Power BI

  • Data Stories
    • Power BI Stories
    • 1 dataset, 100 matplotlib visualizations
  • Learning Portal
    • Download Center
    • 25 Days Challenge
    • DAX Glossary
    • Power BI
    • Power BI by Topic
    • Python
    • 1 dataset, 100 matplotlib visualizations
  • Courses
    • Power BI Mini Master Class 1: Using a REST API as a data source
    • Power BI Master Class 1: COVID Tracker
    • Introduction to Power BI – FREE Online course
    • M Language + Power Query Course Bundle
    • Power Query Online Training [updated 2022]
    • M Language Online Course: The unofficial and Practical Reference Guide [updated 2025]
    • My Courses
  • Shop
    • Courses
    • Master Classes
    • Template Apps
    • JSON Themes
  • Cart
  • Register/ Log In
    • Become a Member
    • Log In
    • My account
    • My Courses
  • Search
  • Contact
You are here: Home / CM Tooltip Glossary Pro+ / DATATABLE

DATATABLE

posted on November 24, 2017

« Back to Glossary Index

Syntax

DATATABLE (ColumnName1, DataType1, ColumnName2, DataType2…, {{Value1, Value2…}, {ValueN, ValueN+1…}…})

Tutorial with example

In today’s video we go through the DAX function DATATABLE.

The allowed DataTypes are:

  1. INTEGER: Whole number
  2. DOUBLE: Decimal Number
  3. STRING: Text
  4. BOOLEAN: True/False
  5. CURRENCY
  6. DATETIME

Download example file:

The file is available for download here.

Other ways to create data tables in DAX:

Option 1:

DAX Fridays! #55: Table construct

Option 2:

DAX Fridays! #56: ROW

Remarks

N/A

Was this helpful?
« Back to Index

Reader Interactions

Comments

  1. phanidivi

    January 4, 2019 at 11:27 am

    Excellent Video and explanation mammmmm

    Reply
    • Ruth Pozuelo Martinez

      January 6, 2019 at 1:05 pm

      Glad you liked it!
      /Ruth

      Reply
  2. stephanieg15

    December 8, 2017 at 5:42 pm

    An example of code on this page would be helpful 🙂 Great video!

    Reply
    • Ruth Pozuelo Martinez

      December 8, 2017 at 6:39 pm

      Hi Stephani,
      Do you mean a power bi sample file? and thanks 🙂
      /Ruth

      Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Footer CTA

Join our community of +50,000 professionals

Become a Member

Subscribe to YouTube

About me:

Curbal AB
Badhusgatan 7B
722 15 – Västerås
Sweden

OrgNo: 5569680852 | VAT: SE556968085201

 

Location:

© Copyright 2014-2025 · Curbal AB · All Rights Reserved · Privacy Policy · Terms of Service · Refund Policy · Log In