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])

3 Replies

  • 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'[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])