Measure: Total Previous Quarter Sales

CollapseAll image

Collapse image Measure properties


 Property   Value 
 Format    
 Format string   '\$#,0.00;(\$#,0.00);\$#,0.00' 
 Measure type   User 
 Is default field set   False 

Collapse image Command


----------------------------------------------------------
-- PowerPivot measures command (do not modify manually) --
----------------------------------------------------------


CREATE MEASURE 'Sales Territory'[Total Previous Quarter Sales]=CALCULATE([Total Sales], PREVIOUSQUARTER('Date'[Date]));

Collapse image See also


About this documentation