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 ...
Need Help
  • mahoneypat's avatar
    mahoneypat
    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

mahoneypat's avatar
mahoneypat
Microsoft Employee
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