crosstable link to calendar table and running total on MAT
I would appreciate urgent help with the following
I have loaded a crosstable into the model with success, but my linking to my master calendar doesn't work and i need to calculate running total for 5 MAT periods. See my attached word document for detail description.
The solution looks reasonable, but note that when you use the crosstable() function with a table that has columns with dates the data in the resulting table is going to be a string and not a date. So, after doing the crosstable, I would call the resulting table to transform the dates as you did in the master calendar.
(Date(Date#(TempDate,'DD/MM/YYYY'),'DD/MM/YYYY')) as Dates,
After transforming the format then I would continue with making the master calendar. You then shouldn't have to do the date#() function in the master calendar.
I have implemented your suggestion and this seems to be the solution except the Dates is not returning any value , it return all fields but the Dates in my case %key field returns just -, as soon as i just put in Tmp_Dates it returns a value but obviously the link to calendar table is wrong. See my code below. Thank you for your help.