Forum Discussion
JamesBurke
Helper III
Helper IIIMax Month -1
Hi , Max Month Usages = Var MaxMonthValue = CALCULATE(MAX('Date'[Year Month Number]) , FILTER('Date',[UsagesCount] >= 1)) RETURN CALCULATE([Total Kwh],'Date'[Year Month Number] = MaxMonthVal...
JamesBurkeHelper III
Helper IIII'm not able to share my dataset unfortunately
JamesBurkeHelper III
Helper IIIMax Month Usages -1 =
Var MaxMonthValue =
CALCULATE(
MAX('Date'[Year Month Number])-1 ,
ALL('Date'),
FILTER('Date',[UsagesCount] >= 1))
RETURN
CALCULATE(
[Total Kwh],'Date'[Year Month Number] = MaxMonthValue)
Does not have an error when using the Filter function however returns blank still