Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
The documentation here:
https://msdn.microsoft.com/en-us/library/mt674921.aspx
Says that DATE(2009,1,1) is a valid value, but this returns an error.
VAR Holidays = DATATABLE("Date",DATETIME, { {DATE(2017,12,25)} })
The error is:
"The tuple at index '1' from the table definition of the DATATABLE function does not have a constant expression in the column at index '1'.
Either the documentation is in error or there is a bug or I can't read directions.
A single argument using Excel syntax for a one dimensional array constant, nested to provide an array of arrays. This argument represents the set of data values that will be in the table
For example,
{ {values in row1}, {values in row2}, {values in row3}, etc. }
Where {values in row1} is a comma delimited set of constant expressions, namely a combination of constants, combined with a handful of basic functions including DATE, TIME, and BLANK, as well as a plus operator between DATE and TIME and a unary minus operator so that negative values can be expressed.
The following are all valid values: 3, -5, BLANK(), DATE(2009,4,15)+TIME(2,45,21) Values may not refer to anything outside the immediate expression, and cannot refer to columns, tables, relationships, or anything else.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.