68 lines
1.8 KiB
Plaintext
68 lines
1.8 KiB
Plaintext
table MQY
|
|
lineageTag: d1b1f83d-7eb1-4ff3-bfdb-4ef33a10fca8
|
|
|
|
calculationGroup
|
|
|
|
calculationItem MTH = SELECTEDMEASURE()
|
|
|
|
calculationItem QTD = CALCULATE(SELECTEDMEASURE(), DATESQTD(Dim_Calendar[Date]))
|
|
|
|
calculationItem YTD = CALCULATE(SELECTEDMEASURE(), DATESYTD(Dim_Calendar[Date]))
|
|
|
|
calculationItem QTDAvg =
|
|
CALCULATE (
|
|
DIVIDE (
|
|
SELECTEDMEASURE ( ),
|
|
COUNTROWS ( VALUES ( Dim_Calendar[YYYYMM] ) )
|
|
),
|
|
DATESQTD ( Dim_Calendar[DATE] )
|
|
)
|
|
|
|
calculationItem HYTDAvg =
|
|
VAR Y = MAX ( Dim_Calendar[YEAR] )
|
|
VAR M = MAX ( Dim_Calendar[MONTH] )
|
|
VAR DT0 = IF ( M <= 6, DATE ( Y, 1, 1 ), DATE ( Y, 7, 1 ) )
|
|
VAR DT1 = MAX ( Dim_Calendar[DATE] )
|
|
RETURN
|
|
CALCULATE (
|
|
DIVIDE (
|
|
SELECTEDMEASURE ( ),
|
|
COUNTROWS ( VALUES ( Dim_Calendar[YYYYMM] ) )
|
|
),
|
|
DATESBETWEEN ( Dim_Calendar[DATE], DT0, DT1 )
|
|
)
|
|
|
|
calculationItem RHYAvg =
|
|
|
|
VAR Y = MAX(Dim_Calendar[Year])
|
|
VAR M = MAX(Dim_Calendar[MONTH])
|
|
VAR DT = IF(M<=6, DATE(Y,1,1), DATE(Y,7,1))
|
|
VAR DT0 = DATE(YEAR(DT), MONTH(DT)-6,1)
|
|
VAR DT1 = DATE(YEAR(DT0), MONTH(DT0)+5,1)
|
|
RETURN CALCULATE(
|
|
AVERAGEX(VALUES(Dim_Calendar[YYYYMM]), SELECTEDMEASURE()+0),
|
|
DATESBETWEEN(Dim_Calendar[Date], DT0, DT1)
|
|
)
|
|
//return DT1
|
|
|
|
column Period
|
|
dataType: string
|
|
lineageTag: cd2f1dfe-55bd-4315-8569-5f3d985e5936
|
|
summarizeBy: none
|
|
sourceColumn: Name
|
|
sortByColumn: 序号
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column 序号
|
|
dataType: int64
|
|
formatString: 0
|
|
lineageTag: e563ba22-724a-4b45-b545-567fcba9d094
|
|
summarizeBy: sum
|
|
sourceColumn: Ordinal
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
annotation TabularEditor_TableGroup = 02_CalGroup
|
|
|