Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Calculation - Continuance

I have been asked to perform a calculation to show continuance probabilities which uses a multiplication of two measures in the prior month, one of which is the value I'm trying to caclulate.  In .xl...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    Hi, Anonymous 

    Are you referring to  function 'PREVIOUSMONTH' ? It is a time intelligent function, you need to ensure that you have a continuous date table when using it.

    As mentioned by amitchandak ,you can also create a Index column in Advanced Editor.

    Then you can try formula as below :

     

    Column2 = CALCULATE(MAX('Table'[Column1]),FILTER('Table','Table'[Index]=EARLIER('Table'[Index])-1))
    continuance probabilities = 'Table'[Column1]*'Table'[Column2]

     

     

    Best Regards,
    Community Support Team _ Eason

v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, Anonymous 

Are you referring to  function 'PREVIOUSMONTH' ? It is a time intelligent function, you need to ensure that you have a continuous date table when using it.

As mentioned by amitchandak ,you can also create a Index column in Advanced Editor.

Then you can try formula as below :

 

Column2 = CALCULATE(MAX('Table'[Column1]),FILTER('Table','Table'[Index]=EARLIER('Table'[Index])-1))
continuance probabilities = 'Table'[Column1]*'Table'[Column2]

 

 

Best Regards,
Community Support Team _ Eason