81 lines
2.2 KiB
Plaintext
81 lines
2.2 KiB
Plaintext
table Trend
|
|
lineageTag: 4b3de547-b947-48b4-95ad-fe3a485d3548
|
|
|
|
calculationGroup
|
|
precedence: 1
|
|
|
|
calculationItem YM = ```
|
|
IF(ISFILTERED(Dim_Calendar_Alt),
|
|
IF([Trend_Is_In_DateRange]>0,
|
|
CALCULATE(
|
|
SELECTEDMEASURE(),
|
|
REMOVEFILTERS(Dim_Calendar),
|
|
REMOVEFILTERS(Dim_Calendar_Alt),
|
|
TREATAS(VALUES(Dim_Calendar_Alt[YYYYMM]),Dim_Calendar[YYYYMM]),
|
|
MQY[Period]="MTH"
|
|
)
|
|
),SELECTEDMEASURE()
|
|
)
|
|
```
|
|
|
|
calculationItem YQ = ```
|
|
IF(ISFILTERED(Dim_Calendar_Alt),
|
|
IF([Trend_Is_In_DateRange.Q]>0,
|
|
CALCULATE(
|
|
SELECTEDMEASURE(),
|
|
REMOVEFILTERS(Dim_Calendar),
|
|
REMOVEFILTERS(Dim_Calendar_Alt),
|
|
TREATAS(VALUES(Dim_Calendar_Alt[YYYYMM]),Dim_Calendar[YYYYMM]),
|
|
MQY[Period]="MTH"
|
|
)
|
|
),SELECTEDMEASURE())
|
|
```
|
|
|
|
calculationItem YQ1 = ```
|
|
IF(ISFILTERED(Dim_Calendar_Alt),
|
|
IF([Trend_Is_In_DateRange.Q1]>0,
|
|
CALCULATE(
|
|
SELECTEDMEASURE(),
|
|
REMOVEFILTERS(Dim_Calendar),
|
|
REMOVEFILTERS(Dim_Calendar_Alt),
|
|
TREATAS(VALUES(Dim_Calendar_Alt[YYYYMM]),Dim_Calendar[YYYYMM]),
|
|
MQY[Period]="MTH"
|
|
)
|
|
),SELECTEDMEASURE())
|
|
```
|
|
|
|
calculationItem YM1 = ```
|
|
IF(ISFILTERED(Dim_Calendar_Alt),
|
|
IF([Trend_Is_In_DateRange1]>0,
|
|
CALCULATE(
|
|
SELECTEDMEASURE(),
|
|
REMOVEFILTERS(Dim_Calendar),
|
|
REMOVEFILTERS(Dim_Calendar_Alt),
|
|
TREATAS(VALUES(Dim_Calendar_Alt[YYYYMM]),Dim_Calendar[YYYYMM]),
|
|
MQY[Period]="MTH"
|
|
)
|
|
),SELECTEDMEASURE()
|
|
)
|
|
```
|
|
|
|
column Name
|
|
dataType: string
|
|
lineageTag: 3c626773-a33b-44e7-8cef-f8942a725f22
|
|
summarizeBy: none
|
|
sourceColumn: Name
|
|
sortByColumn: 序号
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column 序号
|
|
dataType: int64
|
|
formatString: 0
|
|
lineageTag: 90ce4874-5f57-4551-b8b9-2a430639c20c
|
|
summarizeBy: sum
|
|
sourceColumn: Ordinal
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
annotation TabularEditor_TableGroup = 02_CalGroup
|
|
|