I am trying to leverage Date Parameters to control the content and aggregation of my measures.
When I was try to perform a "date difference" between my two parameters, the results are incorrect.
When I change the aggregation from SUM to AVG, the values are correct.
Can anyone explain why? This happens with my other measures as well.
Workbook is attached (Version 10.4)
Thanks in advanced,