2 Replies Latest reply: Dec 1, 2016 11:25 AM by Scott Cunningham RSS

    Most Efficient Way of Showing Max Available Date Only in a Table

      I have a rather large table - about 15 dimensions and 10 measures in all, across a few source tables.


      I would like to only show data for the latest available Reporting Date dimension, according to the user selections.


      Previously I had all 10 measures contain set analysis for the latest date.


      However, I wanted to see if there was a more efficient way of doing this?


      I tried a calculated dimension, though, I'm unsure if that is much better. It seems to take the same amount of time.


      Calc'd dimension I used =



      In a lot of blog posts I've read, they warn against using any calculated dimensions. Though, the same posts warn about over using set analysis.