Measure1 = var _today = today() var _MaxDate = [OSMaxDate_GEN] var _MinOSDate = [OSMinDate_GEN] var _1QTR = IF(CALCULATE([MEASURE], DATEADD(SnapshotDate[Max_OS], -1, QUARTER)) >0, DATEADD(SnapshotDate[Max_OS], -1, QUARTER), _MinOSDate) var _2QTR = IF(CALCULATE([MEASURE], DATEADD(SnapshotDate[Max_OS], -2, QUARTER)) >0, DATEADD(SnapshotDate[Max_OS], -2, QUARTER), _MinOSDate) var _3QTR = IF(CALCULATE([MEASURE], DATEADD(SnapshotDate[Max_OS], -3, QUARTER)) >0, DATEADD(SnapshotDate[Max_OS], -3, QUARTER), _MinOSDate) return IF(SnapshotDate[SnapshotDate] = _today, 1, IF(SnapshotDate[SnapshotDate] = _1QTR, 2, IF(SnapshotDate[SnapshotDate] = _2QTR, 3, IF(SnapshotDate[SnapshotDate] = _3QTR, 4, 0 )))) Measure2 = var _history = CALCULATETABLE(VALUES('Table'[Key]), Month('Date'[SnapshotDate]) = MONTH(MAX('Date'[SnapshotDate]))-1) var _current = CALCULATETABLE(VALUES('Table'[Key])) var devices_not_found = COUNTROWS( EXCEPT( _history, _current)) + 0 var new_devices = COUNTROWS( EXCEPT(_current, _history)) + 0 return devices_not_found Measure3 = var PMo = IF(ISBLANK(CALCULATE([Measure], PARALLELPERIOD('Date'[SnapshotDate], -1, MONTH))), [Measure], CALCULATE([Measure], PARALLELPERIOD('Date'[SnapshotDate], -1, MONTH))) var PQu = IF(ISBLANK(CALCULATE([Measure], PARALLELPERIOD('Date'[SnapshotDate], -1, QUARTER))),[Measure], CALCULATE([Measure], PARALLELPERIOD('Date'[SnapshotDate], -1, QUARTER))) var Selection = IF(ISFILTERED('Date'[SnapshotMonthInCalendar]), PMo, IF(ISFILTERED('Date'[SnapshotQuarterInCalendar]), PQu, blank())) return IFERROR(ROUNDDOWN(([Measure] - Selection)/ Selection, 2), [Measure] * 1) Measure4 = IF(SnapshotDate[YYYYMM] = 202108, (1 + int(DIVIDE((SnapshotDate[SnapshotDate] - WEEKDAY(SnapshotDate[SnapshotDate], 3) + 1) - (DATE(year(SnapshotDate[SnapshotDate]), month(SnapshotDate[SnapshotDate]), 1)), 7))) - 1, 1 + int(DIVIDE((SnapshotDate[SnapshotDate] - WEEKDAY(SnapshotDate[SnapshotDate], 3) + 1) - (DATE(year(SnapshotDate[SnapshotDate]), month(SnapshotDate[SnapshotDate]), 1)), 7))) Measure5 = IF([Measure] >= [UpperTarget Measure], 1, if([Measure] >= [LowerTarget Measure], 0, -1)) Measure6 = IF([PCT_PreviousPeriodQoQ_GEN] >= CALCULATE([UpperTargets_GEN], USERELATIONSHIP(SnapshotDate[-1QTR], 'BoardReporting_Year'[SnapshotYear])), 1, IF([PCT_PreviousPeriodQoQ_GEN] >= CALCULATE([LowerTargets_GEN], USERELATIONSHIP(SnapshotDate[-1QTR], 'BoardReporting_Year'[SnapshotYear])), 0, -1))