I hope I've got my row / filer the the right way round,
I created two measures one using the dates from the fact table the other from the calendar table
and the same but rather than using calendar table using the dates form the fact table
they both work on their respective matrix's 'matrices'? , but when another element is dropped in
the matrix using the calendar still returns a running total by date ignoring the current 'row', so as can be seen March 7th returns 42, correct in both cases but
for the 'calendar' not exactly what i want, any suggestion on making it work properly,, like the second one. ignore RTM using C just dropped in to see what would happen.
I created two measures one using the dates from the fact table the other from the calendar table
SQL:
RTM using C = VAR mcdate = MAX('Calendar'[Date])
VAR anser = CALCULATE([Tsales],FILTER(ALL('Calendar'[Date]),'Calendar'[Date]<= mcdate))
RETURN IF([Tsales],anser )and the same but rather than using calendar table using the dates form the fact table
SQL:
RTM using Rsaels Date =
VAR maxdate = MAX(RTsales[Date])
VAR anser2 = CALCULATE([Tsales],FILTER(ALL(RTsales[Date]),RTsales[Date]<= maxdate))
VAR iff = IF([Tsales], anser2 )they both work on their respective matrix's 'matrices'? , but when another element is dropped in
the matrix using the calendar still returns a running total by date ignoring the current 'row', so as can be seen March 7th returns 42, correct in both cases but
for the 'calendar' not exactly what i want, any suggestion on making it work properly,, like the second one. ignore RTM using C just dropped in to see what would happen.
