Last Modified Date: 11 Jan 2017
Option 1:Change the aggregation on the DATEDIFF() measure in the view from SUM() to MIN().
Option 2:Change the DATEDIFF() calculation from a measure to a dimension by dragging it from Measures to Dimensions in the data pane.
Note: See the attached packaged workbook for a comparison of the two options.
CauseUsing the DATEDIFF() function creates a measure by default, and when added to the view it is aggregated as SUM() unless the default aggregation is altered.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials