|
MOM PY MTD User Registers
|
'Fact User Registers'[MTD User Registers] - 'Fact User Registers'[PY MTD User Registers] |
|
|
MOM User Registers
|
'Fact User Registers'[Sum of User Register Count] - 'Fact User Registers'[PM User Registers] |
|
|
MOM% User Registers
|
DIVIDE ([MOM User Registers], 'Fact User Registers'[PM User Registers]) |
|
|
MTD User Registers
|
TOTALMTD([Sum of User Register Count],'User Registers Date'[User Registers Date Full Date]) |
|
|
PM User Registers
|
CALCULATE (
[Sum of User Register Count],DATEADD(DATESMTD ('User Registers Date'[User Registers Date Full Date]), -1, MONTH)
) |
|
|
POP User Registers
|
'Fact User Registers'[Sum of User Register Count] - 'Fact User Registers'[PP User Registers] |
|
|
POP% User Registers
|
DIVIDE ([POP User Registers], 'Fact User Registers'[PP User Registers]) |
|
|
PP User Registers
|
SWITCH (
TRUE,
ISFILTERED ( 'User Registers Date'[User Registers Date Month Abbreviation]) , 'Fact User Registers'[PM User Registers],
ISFILTERED ( 'User Registers Date'[User Registers Date Quarter Name]) , 'Fact User Registers'[PQ User Registers],
ISFILTERED ( 'User Registers Date'[User Registers Date Year]) , 'Fact User Registers'[PY User Registers],
BLANK ()
) |
|
|
PQ User Registers
|
CALCULATE (
[Sum of User Register Count],DATEADD('User Registers Date'[User Registers Date Full Date], -1, QUARTER)
) |
|
|
PY MTD User Registers
|
CALCULATE(
[Sum of User Register Count],
SAMEPERIODLASTYEAR(DATESMTD('User Registers Date'[User Registers Date Full Date]))
) |
|
|
PY QTD User Registers
|
CALCULATE(
[Sum of User Register Count],
SAMEPERIODLASTYEAR(DATESQTD('User Registers Date'[User Registers Date Full Date]))
) |
|
|
PY User Registers
|
CALCULATE (
[Sum of User Register Count],DATEADD('User Registers Date'[User Registers Date Full Date], -1, YEAR)
) |
|
|
PY YTD User Registers
|
CALCULATE(
[Sum of User Register Count],
SAMEPERIODLASTYEAR(DATESYTD('User Registers Date'[User Registers Date Full Date]))
) |
|
|
QOQ PY QTD User Registers
|
'Fact User Registers'[QTD User Registers] - 'Fact User Registers'[PY QTD User Registers] |
|
|
QOQ User Registers
|
'Fact User Registers'[Sum of User Register Count] - 'Fact User Registers'[PQ User Registers] |
|
|
QOQ% User Registers
|
DIVIDE ([QOQ User Registers], 'Fact User Registers'[PQ User Registers]) |
|
|
QTD User Registers
|
TOTALQTD([Sum of User Register Count],'User Registers Date'[User Registers Date Full Date]) |
|
|
Sum of User Register Count
|
SUM([User Registers Count]) |
|
|
YOY PY YTD User Registers
|
'Fact User Registers'[YTD User Registers] - 'Fact User Registers'[PY YTD User Registers] |
|
|
YOY User Registers
|
'Fact User Registers'[Sum of User Register Count] - 'Fact User Registers'[PY User Registers] |
|
|
YOY% User Registers
|
DIVIDE ([YOY User Registers], 'Fact User Registers'[PY User Registers]) |
|
|
YTD User Registers
|
TOTALYTD([Sum of User Register Count],'User Registers Date'[User Registers Date Full Date]) |
|