Forum Discussion

os_ca's avatar
os_ca
Frequent Visitor
5 years ago
Solved

PreviousYear() Function doesn't work

I can't figure out why PreviousYear() function doesn't work. What is worng with my formula with PreviousYear()?   There are colums in a table in a report. Product Category | Calendar Year | Total ...
  • mahoneypat's avatar
    5 years ago

    Is your Date table "Marked as Date Table"?  You are using the alternatekey column in DimDate.  Is that the one that was validated when you made the date table?

     

    Regards,

    Pat