Forum Discussion

Cunners123's avatar
Cunners123
Regular Visitor
4 years ago
Solved

Calculating absolute values from cumulative data set

Hi, I am trying to calculate the absolute month values (in month difference) from a cumulative data set.  Where am I going wrong with the formular?       thanks James
Need Help
  • Cunners123's avatar
    Cunners123
    4 years ago

    Thanks  ryan_mayu . That has worked but I realised  I left a fundamental part out. I will have different sites so want to apply this calculation per site i.e so I get the january absolute value for site 1 and site 2 (i will have lots of sites in reality) is there a quick edit to account for this?

     

    Using current formula it goes a bit wrong

     

     

    Thanks for your help

    James

  • ryan_mayu's avatar
    ryan_mayu
    4 years ago

    Cunners123 

    pls try this

    Column = 'Table'[cumulative]-maxx(FILTER('Table','Table'[Month]=EDATE(EARLIER('Table'[Month]),-1)&&'Table'[site]=EARLIER('Table'[site])),'Table'[cumulative])

Cunners123's avatar
Cunners123
Regular Visitor
4 years ago

Thanks  ryan_mayu . That has worked but I realised  I left a fundamental part out. I will have different sites so want to apply this calculation per site i.e so I get the january absolute value for site 1 and site 2 (i will have lots of sites in reality) is there a quick edit to account for this?

 

Using current formula it goes a bit wrong

 

 

Thanks for your help

James

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    4 years ago

    Cunners123 

    pls try this

    Column = 'Table'[cumulative]-maxx(FILTER('Table','Table'[Month]=EDATE(EARLIER('Table'[Month]),-1)&&'Table'[site]=EARLIER('Table'[site])),'Table'[cumulative])