This content has been marked as final. Show 2 replies
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.