Measure: Total Inventory Value
Measure properties
| Property | Value |
| Format | |
| Format string | '\$#,0.00;(\$#,0.00);\$#,0.00' |
| Measure type | User |
| Is default field set | False |
Command
---------------------------------------------------------- -- PowerPivot measures command (do not modify manually) -- ---------------------------------------------------------- CREATE MEASURE 'Product Inventory'[Total Inventory Value]=CALCULATE(SUM([Product-Date Inventory Value]),LASTDATE('Product Inventory'[Movement Date])); |
See also