Jarvis,

Here are some answers to your previous questions:

A: The Weekday calculation only includes days from Monday-Friday I looked through the data and all of the dates where there is closing prices and volume data are all on Weekedays. This is why I marked this calculation as TRUE as a filter on the page so that only data will show that is on a Weekday. There really is much of a need for you new column you added. I you wish to add it, you would need to apply the same logic as I did in the Pricing Data Exists column.

B: You are correct that the measure calculation of the moving averages is by calendar month, but when you apply the Weekday is TRUE as a filter on this page, it will calculate those averages based only on Weekdays. I also have the Pricing Data Exists column as a page filter as well.

C: I will need to work on solving this issue, because it doesn’t currently work the way you want it to.

D: The 30 Days Ago & 7 Days Ago Measures are showing same numbers because it is going off the MAX Date in the date range on the page. You are correct in thinking that once we solve C, D can be answered with similar logic.

E: The way this is currently designed you would still want whatever Stock you want to be the default if it is not filtered, just in case there ever is a situation where it might not be filtered. Don’t get hung up on this one, leave it as is.

** I will start to work on answers for C & D **

Thanks

Jarrett