Which of the following DAX functions do not return a table?
Answers
Answer:
Excel date and time functions return an integer that represents a date as a serial number. DAX date and time functions return a datetime data type that is in DAX but not in Excel. Excel has no functions that return a table, but some functions can work with arrays.
Explanation:
hope its help full
Answer:
The date and time functions in Excel return an integer that serialises a date. The datetime data type that is returned by DAX date and time operations is present in DAX but not in Excel. Although several functions in Excel may operate with arrays, there are no functions that return tables.
Explanation:
The date and time functions in Excel return an integer that serialises a date. The datetime data type that is returned by DAX date and time operations is present in DAX but not in Excel. Although several functions in Excel may operate with arrays, there are no functions that return tables.
The formula expression language known as Data Analysis Expressions (DAX) is utilised in Excel's Power Pivot, Analysis Services, and Power BI. To execute complex computations and queries on data in connected tables and columns in tabular data models, DAX formulae comprise functions, operators, and values. The values relevant to the current row are returned by DAX Filter functions as a column or table.
#SPJ3