Date/Time Intelligent Dax in Matrix

Hi edhans 

Thanks for the tips, I always forget to use VAR and RETURN functions so this is very helpful and something I will keep in mind.

Regarding my issue.

So I have a date table which I use the activity date from across all my visuals, the date table however is not marked as a date table as this doesn't allow me to add a hierachy to the matrix, unless I use the calendar_year and quarter_nbr columns. But this gives me the same result anyway.

So I have a matrix which shows the overall position of a client for the date range give (last 11 weeks)

However, I have another matrix which also uses dates from the same date table, however I have editted the interaction of this table so that it is not filtered by the Last 11 weeks Date Slicer.

This allows me to show how the fill rates change over the past couple of Years/Quarter. The Fill Rate% (Closed) otherwise known as Overall Fill Rate calculate fine for year quarter and year.

However the historic fill rate (Fill Rate% Historical) and the forecast fille rate (Fill rate% Forecast) are giving the same return as the Fill Rate% Closed which is not right.

I would expect the Historical Fill Rate to calculate for each Year/QTR from the start of time to the end date of the given Year/QTR in the matrix.

For Fill Rate I would only expect to see a value here for the current period/period which have a value in the Positions Rem. calculation given above in those periods. But this also doesn't look to be happening as this to is the same as the Fill Rate% Closed calculation.