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

    Andrew Burns

      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 =

      If(Num(REPORTING_DATE)=$(=(max(REPORTING_DATE))), REPORTING_DATE, null)

       

      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.