Forum Discussion
Solved
SamePeriodLastYear - does not work when adding date to the table?
There are a ton of posts here about SamePeriodLastyear, but I have not been able to find one that describes my problem: * Using AutoQuery to SQL * Created Dates table using CalendarAuto(12) * C...
RobvB , you need to add a date column from the date table ITK_Dates. you need to use ITK_Dates[Date]
Use the Date column from your date table intead of the TransDate column from fact table.
Regards,
Pat
RobvB , you need to add a date column from the date table ITK_Dates. you need to use ITK_Dates[Date]