When i used Max(DATE) it will return me the Max Date according to the dimension, but when i used =$(=MAX(DATE)). its return me all 16 value which is max over through the application.
How can i write a Variable in such way that it work same like MAX(DATE).
Hi Jitendra, in a simple way I think in set analysis like something to create a dataset with less records and use it to create the chart, so with less records it calculates faster.
If it worked row by row then it will lost his ability to give faster results, and his behaviour will be no much different than any other functions in terms of performance.
It's only my thoughts, I don't have knowledge of how it really works.
