Sales Build Month over Month

[bryantmikdbi]

FYI - I'm actually using powerpivot, but I pretty sure the dax will still work.  I need help trying to calculate a month over month sales build.  I'm struggling to get it to work at all.  

I have a date table that is populatng the Season,Quarter, Current Month columns.  Vendor ID is it's own table.  Grs Sls is the following measure:

Grs Sls $:=sumx(Dates,(if([Gross Sls $ TY Act]>0,[Gross Sls $ TY Act],[Grs Sls $ Proj])))

For example what I want is a measure that takes (March Grs Sls $ - Feb Grs Sls $)/Feb Grs Sls $+1 and then repeat accordingly.

The tables are joined using the actual month name (Current Month)

Thanks!

Vendor Name ID	Season	Quarter	Current Month	Grs Sls $
Footwear	Spring	Q121	February	$2,469,502
Footwear	Spring	Q121	March	$2,689,803
Footwear	Spring	Q121	April	$1,826,877
Footwear	Spring
Footwear	Spring	Q221	May	$2,046,957
Footwear	Spring	Q221	June	$2,292,293
Footwear	Spring	Q221	July	$2,215,367
Footwear	Spring
Footwear
Footwear	Fall	Q321	August	$1,810,601
Footwear	Fall	Q321	September	$3,156,480
Footwear	Fall	Q321	October	$3,621,600
Footwear	Fall
Footwear	Fall	Q421	November	$5,043,080
Footwear	Fall	Q421	December	$5,392,790
Footwear	Fall	Q421	January	$2,692,170

[Greg_Deckler]

@bryantmikdbi You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000

Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...