Time intelligence calculation group

createOrReplace

	table 'Time Intelligence'

		calculationGroup
			precedence: 1

			calculationItem YTD =
					CALCULATE (
					    SELECTEDMEASURE (),
					    DATESYTD ( 'Calendar'[Date] )
					)

			calculationItem QTD =
					
					CALCULATE (
					    SELECTEDMEASURE (),
					    DATESQTD ( 'Calendar'[Date] )
					)

			calculationItem MTD =
					CALCULATE (
					    SELECTEDMEASURE (),
					    DATESMTD ( 'Calendar'[Date] )
					)

			calculationItem PY =
					
					CALCULATE (
					    SELECTEDMEASURE (),
					    SAMEPERIODLASTYEAR ( 'Calendar'[Date] )
					)

			calculationItem YOY% =
					
					DIVIDE (
					    CALCULATE (
					        SELECTEDMEASURE (),
					        'Time Intelligence'[Show as] = "YOY"
					    ),
					    CALCULATE (
					        SELECTEDMEASURE (),
					        'Time Intelligence'[Show as] = "PY"
					    )
					)

				formatStringDefinition = "#,##0.00%"

			calculationItem YOY =
					
					SELECTEDMEASURE ()
					    - CALCULATE (
					        SELECTEDMEASURE (),
					        'Time intelligence'[Show as] = "PY"
					    )

			calculationItem Current = SELECTEDMEASURE()

		column 'Show as'
			dataType: string
			summarizeBy: none
			sourceColumn: Name
			sortByColumn: Ordinal

		column Ordinal
			dataType: int64
			formatString: 0
			summarizeBy: sum
			sourceColumn: Ordinal