Forum Discussion
Group By or Summarize Help Needed
Hello to all. I am working on a project in Power Pivot in Excel and am stuck on a DAX formula. I am wanting to calculate total sales for 52, 13 and 4 at a total for each time period. Once I get tha...
The Pivot table would look something like this. Trying to calculate the total $ of each time period, so that I can then take that number, use it as the denominator in a share change equation by state.
TX $ Sales/52 week total $ number
| State | TY Sales | $ Trend | $ Share | Share Change |
| TX | 222,222 | +4% | 14.2% | +0.3 |
| MO | 111,111 | -3% | 8% | -0.2 |
tamerj1
Community Champion
Community ChampionI don't have enough information to build a complete measure formula but I as per my understanding you need to do something like this
SUMX (
VALUES ( 'Table'[Time Period] ),
VAR TotalPeriod = CALCULATE ( SUM ( 'Table'[Sales TY] ) )
RETURN
(Your share change equation)
)