Forum Discussion
Calculated Columns Errors
I'm unable to find this solution posted elsewhere; apologies if this has already been answered I'm attempting to calculate the "cost per item" up through a certain fiscal week for both 2015 and 2...
I would think a measure in the form of:
2015 Cost Per Item = SUM([2015 Sales Dollars]) / SUM([2015 Sales Qty)
2016 Cost Per Item = SUM([2016 Sales Dollars]) / SUM([2016 Sales Qty])
Create a table for [Fiscal Week], [Item] and your two new measures.
Edit: Oh wait, you would probably need a another measure for a running total/average, look at daxpatterns.com for running total/average patterns. Should be able to use them with your two new measures.
Also if you do have a calendar table several of the time Intel functions can take as a parameter FY end say eg (6/30)
