Forum Discussion
ROG
Responsive Resident
Responsive ResidentMeasure using another measure minus previous date.
Hi all, I would like to add another column the table below that show me the 'Opening Base'. I know that the 'Opening Base' is sum(active_customers) from fsubscriber_table on the last day of th...
Hey, that works! Thank you.
vapid128
Solution Specialist
Solution Specialistadd colnum:
YYMM = YEAR([date])*12+MONTH([date])
Measure 2 =
var _lastDate = CALCULATE(MAX([date]),FILTER(ALL(table22), table22[YYMM]= MAX(table22[YYMM])-1))
return CALCULATE([Measure],FILTER(ALL(table22),table22[date]=_lastDate))
Measure 3 =
IF(DAY( MIN(table22[date]))=1,
[Measure 2],
[Measure]
)
ROGResponsive Resident
Responsive ResidentHey, that works! Thank you.