Find Highest value

How to find the highest value for the regions amongst the 3 months and show that highest value in module Test Case 2?KQ1.jpg


Best Answer


  • @Kiran96 


    While your solution works, I wouldn't advise it because you are hardcoding to a certain time member.  What happens when the model rolls to another year?  The proper solution would be to use the MAX aggregation function if you have All Periods turned on under your Time settings or TIMESUM() with the aggregation method of MAX.