This content has been marked as final. Show 2 replies
I am trying to show a value of a measure 12 months ago. I've been able to get some success using this formula:
But it involves actually having the full 12 months on the screen. I would like to be able to report on a single headline figure for my dashboard. In this example i would like to report on 0.7768 as my headline figure. How do i do this without hiding the rest of the fields?
Note: Hiding is not ideal as by the time the next month comes along, you will need to manually hide it. I know there must be some way of using the date calculations but not sure how to proceed.
Thanks in Advance,