
1. Re: How do we get the value of the last row of the underlying data set within each partition.
John Sobczak Aug 16, 2016 3:31 AM (in response to Shaun Purdy)I'm not sure this is what you are looking for but it does give the stated amount.

2. Re: How do we get the value of the last row of the underlying data set within each partition.
Mahfooj Khan Aug 16, 2016 4:19 AM (in response to Shaun Purdy)2 of 2 people found this helpfulHave a look and let us know is that what you wanted?
workbook (version 9.3) attached for your reference.
Mahfooj

3. Re: How do we get the value of the last row of the underlying data set within each partition.
Shaun Purdy Aug 16, 2016 5:51 AM (in response to Mahfooj Khan)Hi Mahfooj,
Very helpful, thanks!
Unfortunately it seems to fall down if we drill down on Month(Period EndUTC) to Week or Day.
It looks like it's the 'Max Date of Avg Bank Balance' that needs to calculate differently based on the granularity of the date on the row shelf.
Is there a way to do this we're missing?
Thanks again for your help thus far.
Cheers,
Shaun

4. Re: How do we get the value of the last row of the underlying data set within each partition.
Mahfooj Khan Aug 16, 2016 5:59 AM (in response to Shaun Purdy)1 of 1 people found this helpful 
5. Re: How do we get the value of the last row of the underlying data set within each partition.
Shaun Purdy Aug 16, 2016 6:45 AM (in response to Mahfooj Khan)Excellent!!!
I don't entirely understand why that works (at the minute) but it seems to do the trick as we drill down the data.
Thanks for your help
Cheers,
Shaun

6. Re: How do we get the value of the last row of the underlying data set within each partition.
Mahfooj Khan Aug 16, 2016 7:44 AM (in response to Shaun Purdy)I can try to explain how order of filters works in tableau.
1.Extract Filter apply
2.Data Source filters
3. Context Filters
4. Fixed LOD expression
5. Dimension Filters
6. INCLUDE or EXCLUDE LOD expression
7. Measure filters
8. Table Calculation.
Here in your case when we were using FIXED() then while drill down Dimension filter was applying after FIXED that's why we were not getting the correct output.
So I've used INCLUDE so that dimension filter apply before INCLUDE expression. I hope you can understand now.