Returns week number for a given date column.
Syntax
Tutorial with example
IN todays video I will show you how to enter data in Power Pivot as you do in Power Query. Hope you find it useful!
Download example file:
NA
Remarks
The first syntax returns a table of a single column. The second syntax returns a table of one or more columns.
The number of scalar expressions must be the same for all rows.
When the data types of the values for a column are different in different rows, all values are converted to a common data type.
Let us know your thoughts...