Measure: Reseller Previous Quarter Gross Profit
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 'Reseller Sales'[Reseller Previous Quarter Gross Profit]=CALCULATE([Reseller Total Gross Profit],PREVIOUSQUARTER('Date'[Date])); |
See also