STARTOFQUARTER

返回当前季度的第一天。

语法

STARTOFQUARTER ( <日期列> )

参数	属性	描述
日期列		包含日期的列

返回值

表 只有一列的表

备注

<日期列>参数可以是以下任一项：

对日期/时间列的引用。只有在这种情况下才应用上下文转换，因为列引用被替换为CALCULATETABLE ( DISTINCT ( <日期列> ) )
返回单列日期/时间值的表表达式
定义日期/时间值的单列表的布尔表达式

STARTOFQUARTER 和下面的表达式得到相同的结果，但计算效率更高：

VAR FirstDateVisible =
    CALCULATE ( MIN ( 'Date'[Date] ) )
VAR FirstYearVisible =
    YEAR ( FirstDateVisible )
VAR FirstQuarterVisible =
    QUOTIENT ( MONTH ( FirstDateVisible ) - 1, 3 )
VAR DaysInQuarter =
    FILTER (
        ALL ( 'Date'[Date] ),
        YEAR ( 'Date'[Date] ) = FirstYearVisible
            && QUOTIENT ( MONTH ( 'Date'[Date] ) - 1, 3 ) = FirstQuarterVisible
    )
VAR FirstDayInQuarter =
    MINX (
        DaysInQuarter,
        'Date'[Date]
    )
VAR Result =
    CALCULATETABLE (
        VALUES ( 'Date'[Date] ),
        'Date'[Date] = FirstDayInQuarter
    )
RETURN
    Result

VAR FirstDateVisible =
CALCULATE ( MIN ( 'Date'[Date] ) )
VAR FirstYearVisible =
YEAR ( FirstDateVisible )
VAR FirstQuarterVisible =
QUOTIENT ( MONTH ( FirstDateVisible ) - 1, 3 )
VAR DaysInQuarter =
FILTER (
ALL ( 'Date'[Date] ),
YEAR ( 'Date'[Date] ) = FirstYearVisible
&& QUOTIENT ( MONTH ( 'Date'[Date] ) - 1, 3 ) = FirstQuarterVisible
)
VAR FirstDayInQuarter =
MINX (
DaysInQuarter,
'Date'[Date]
)
VAR Result =
CALCULATETABLE (
VALUES ( 'Date'[Date] ),
'Date'[Date] = FirstDayInQuarter
)
RETURN
Result

VAR FirstDateVisible =
    CALCULATE ( MIN ( 'Date'[Date] ) )
VAR FirstYearVisible =
    YEAR ( FirstDateVisible )
VAR FirstQuarterVisible =
    QUOTIENT ( MONTH ( FirstDateVisible ) - 1, 3 )
VAR DaysInQuarter =
    FILTER (
        ALL ( 'Date'[Date] ),
        YEAR ( 'Date'[Date] ) = FirstYearVisible
            && QUOTIENT ( MONTH ( 'Date'[Date] ) - 1, 3 ) = FirstQuarterVisible
    )
VAR FirstDayInQuarter =
    MINX (
        DaysInQuarter,
        'Date'[Date]
    )
VAR Result =
    CALCULATETABLE (
        VALUES ( 'Date'[Date] ),
        'Date'[Date] = FirstDayInQuarter
    )
RETURN
    Result

STARTOFQUARTER 未针对 DirectQuery 进行优化，在计算列和行级别安全性公式中完全不受支持。但可以在度量值和查询公式中使用，只不过无法保证性能。