This content has been marked as final.
Show 2 replies

1. Re: Calculate Difference in a Measure's Value Between First Day and Last Day of Period
kunal.dongre.0 Jul 10, 2018 10:02 AM (in response to Ian Armstrong)Try using lookup function to get the first and the last sales value for the dimensions.
LOOKUP(SUM([Sales]),FIRST())  LOOKUP(SUM([Sales]),LAST())

2. Re: Calculate Difference in a Measure's Value Between First Day and Last Day of Period
Ian Armstrong Jul 11, 2018 4:59 AM (in response to kunal.dongre.0)That did the trick! You're a savior, thanks!
FYI for anyone that stumbles upon this thread with the same question  when I used my real data, I had to convert my measure to an aggregate using ATTR. The formula looked like this:
LOOKUP(ATTR(SUM[Sales])),FIRST())  LOOKUP(ATTR(SUM[Sales])),LAST())