I'm not sure if I caught the gist, but maybe the below
can give some ideas.
I think it's going to take a few steps, mostly requiring Table Calculations.
For the table calculations to work, both [Date] and [Month] will need to be on
the detail shelf. (This will make many copies of the value, but will
take a max and then filter it down to one copy).
Running sum of First Value:
Average of Second Value:
Ytd of only max month:
THEN SUM([Test Ytd])
These will all require Table Calculation settings as shown below.
Lastly, as this created many copies, we will put INDEX() on the Filter shelf,
put table calculation settings same as below, then filter down to just one.
Please see workbook v10.5 attached in the Forum Thread:
285892month.twbx 53.1 KB
Thanks. Hmm.. so i think that's how it might work with window_max. I couldn't figure it out.
I did figure out how to solve the issue eventually. I learned about context filter. So i basically grabbed the max for that measure but then put the filter into context. This will adjust the data before it calculates the max instead of getting the max of all the data first.