I am trying to use BY LASTNONBLANK function to capture the last non blank value in “A” metric (with dimension Month), and get this value in “B” metric (no dimensions there), so that in B metric I will have only the value from most recent Month.
I used the following formula in metric B:
“Metric A” [BY LASTNONBLANK: Month]
The result I am receiving is the sum of all months (the same result I would receive if left “Metric A” in formula without any modifiers).
Do you know how I can retrieve the last nonblank value from the Metric?
Best answer by francoisView original