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