Forum Discussion

JamesBurke's avatar
JamesBurke
Icon for Helper III rankHelper III
2 years ago

Max 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...
Need Help
JamesBurke's avatar
JamesBurke
Icon for Helper III rankHelper III
2 years ago

Thanks for the Quick response, 

 

I'm getting a Function Placeholder is being used Error ? 

AmiraBedh's avatar
AmiraBedh
Icon for Super User rankSuper User
2 years ago

Can you share your dataset ?

  • JamesBurke's avatar
    JamesBurke
    Icon for Helper III rankHelper III
    2 years ago

    I'm not able to share my dataset unfortunately 

    • JamesBurke's avatar
      JamesBurke
      Icon for Helper III rankHelper III
      2 years ago
      Max 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