Forum Discussion
paulalmond91
Helper II
Helper IIIssue with totals on SUMX with GENERATE function
I have a calculation that determines the total value of a sale that falls inside a single month. There is an added complication in that I require this calculation to divide its total between the numb...
- paulalmond91,
Try this and see if it works (I’m assuming your date table has a month column):
Totals = SUMX(SUMMARIZE(‘Date’, Date[Month]), [Optimised Spread])
(Apologies if there is a bracket missing or some other syntax error; I’m typing this on a phone...)
PaulDBrown
Community Champion
Community Championpaulalmond91,
Try this and see if it works (I’m assuming your date table has a month column):
Totals = SUMX(SUMMARIZE(‘Date’, Date[Month]), [Optimised Spread])
(Apologies if there is a bracket missing or some other syntax error; I’m typing this on a phone...)
Try this and see if it works (I’m assuming your date table has a month column):
Totals = SUMX(SUMMARIZE(‘Date’, Date[Month]), [Optimised Spread])
(Apologies if there is a bracket missing or some other syntax error; I’m typing this on a phone...)
paulalmond91Helper II
Helper IIThis is perfect!
Thank you so much!