Forum Discussion

Naveeduddinj077's avatar
Naveeduddinj077
Regular Visitor
3 years ago
Solved

Cumulative Sum Division

Hi Team,   Is it possible to divide a coulum number by sum of other column year wise? I want to know how to get the Yellow highlighted F & G Columns from the below link.   https://docs.google.com...
Need Help
Show and Tell
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    Hi Naveeduddinj 

     

    Are you creating a mesure with the DAX? If yes, try replacing EARLIER function with MAX function.

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

Hi Naveeduddinj077 

 

You can create two calculated columns with below DAX in your original table

Renewal % = DIVIDE('Table'[Existing],CALCULATE(SUM('Table'[New]),ALL('Table'),'Table'[Calendar Year]<EARLIER('Table'[Calendar Year])))
Renewal % 2 = DIVIDE('Table'[Existing],CALCULATE(SUM('Table'[Total]),ALL('Table'),'Table'[Calendar Year]=EARLIER('Table'[Calendar Year])-1))

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

Naveeduddinj's avatar
Naveeduddinj
Regular Visitor
3 years ago

Hi v-jingzhang 

 

I'm getting the below error for second formaula.

 

 

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    3 years ago

    Hi Naveeduddinj 

     

    Are you creating a mesure with the DAX? If yes, try replacing EARLIER function with MAX function.

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

    • Naveeduddinj's avatar
      Naveeduddinj
      Regular Visitor
      3 years ago

      Awesome! This works Thank you