Here's an explanation on what is happening in that function. Maybe a little closer to what you had in mind? "Weighted Price Based on Qty of Market",DIVIDE(, ) "Weighted Price Based on Total of All Qty",DIVIDE(, ), * Using the Price * Quantity measure, the denonminator is either the total sold for the specific market, or the grand total of quantity*/ "Total Sold (Price * Quantity)", CALCULATE( SUMX( Table5, Table5 *Table5)) The standard deviation is not the weighted average of the standard deviation of assets, because the correlation between the asset returns also affects the. "Total Qty for All Markets", SUM( Table5), * Returns the total quantity, regardless of the market */ "Total Quanitity for Specific Market", CALCULATE(SUM( Table5), ALLEXCEPT(Table5, Table5)), * Returns the total quantity of the specific market */ You would probably not actually need to create this table in the model, but it would be used in the measures since you need to pass a column to the standard deviation function.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |