Forum Discussion

Ekta_dq's avatar
Ekta_dq
New Member
5 years ago

Optimising the report

Hi,   I am trying to optimise my report which is fetching the output for two months but not fetching the output for two years. The measure that needs to be optimsed is below: /* Rank = IF (  ...
optimised
quantumudit's avatar
quantumudit
Icon for Super User rankSuper User
5 years ago

Always use ADDCOLUMNS() with SUMMARIZE() and please consider only specific columns (needed for ranking) in the first part of FILTER() function to create the virtual table