cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
naoki Regular Visitor
Regular Visitor

Getting sum of data

I would like to get a sum of a particular data, however there is a problem is that my raw data may have missing data for it. 

Month 1 -> 10k
2 -> 20K 
3 -> 30K 

In this case the sum of all 3 months should be 60k. However what happens is my data which I need it to use as a comparison to the above data to gauge a person performance, may not have any transaction in the first month thus it will only sum up those months with data how do I get it to sum all data? 

2 REPLIES 2
Community Support Team
Community Support Team

Re: Getting sum of data

@naoki 

 

The requirement is not very clear. You may try using SUMX and ALL.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
naoki Regular Visitor
Regular Visitor

Re: Getting sum of data

@v-chuncz-msft 

 

Apologies for the unclear questions. 

Please see below screenshot(This is only a dummy example but it mirrors my actual raw data the same way). 

So lets sat the actual expected sales as of Oct is $550,000 however, as my raw data may have conditions whereby there is no sales for certain month, even after creating a relationship to link the month, my actual expected GP is not $550, 000 but $290,000. This way I am unable to check the particular store sales for YTD, as I would like to see my store actual sales vs expected sales for both MTD and YTD. However, it is only currently working for MTD, my YTD is not showing up correctly. 

 

What other methods do I have? 

Capture.JPG

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,886)