Forum Discussion
SamePeriodLastYear
I have been using the samperiodlast year function to calucation prior year revenues and counts of jobs and quotes. For some reason it has stopped working for me. If I use this calculation then the n...
Are the year and month slicers from your facts table and not your calendar table? If so try swapping them to year/month columns in your calendar table!
/ J
That did it although I do not understand why making that change made the difference.