KB18021: How to calculate a level metric that has a condition based on a dynamic Max Date in MicroStrategy Developer

SYMPTOM
 
There is a scenario where is necessary to create a level metric that brings back just the metric value at the max or min date in Strategy, as shown in the image below from Developer:

ACTION:
The following steps are based in the Strategy Tutorial Project:

• Create a metric that brings back the same elements than the Date attribute (in this example Ship Date). It can be defined as: Max([attribute]){~}, as shown in the example image below:
  

• Note: ShipDate in the formula refers to the attribute.
  
• Save and close the metric and add it to the report, it should contain the same values as the attribute as shown below:
  

• Create a new metric that calculates the max date at Customer level as shown in the image below:
  

• Save and close the metric, add it to the report and add the Revenue metric as shown in the image below:
  

• Create a new Set Qualification filter, where the ShipDate metric is exactly equal to the Max Date metric as shown in the image below:
  

• Note: Users can drag and drop the metric from the Object Browser Window into the metric field or they can browse it.
   
  
• Create a new metric and add the filter already created into it. Set the level to Customer and remove the report level (this depends on the desired dimensionality) as shown below:
  

• Save and close the metric and add it into the report. Execute it and the correct data should appear as it shown below:
  

• ShipDate and Max Date metric may be removed from the report to give a better presentation, as shown below: