Forum Discussion
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 ...
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
os_ca You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000
Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008