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.
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
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.