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