Forum Discussion
Include fields/columns sameperiodlastyear
Hi All, I am trying to calculate last year value. I am using sameperiod last year to achieve this functionality. Keeping in mind that same period last year is a contiguous function, I am using a ...
Is your calendar table at the day level?
is the month/year column in your visual from the calendar table?
More background here https://exceleratorbi.com.au/power-pivot-calendar-tables/
Yes, my calendar table is at day level. The month/year column is from the calender table. All dates are joined using calendar key from other tables. I tried using the date column to join the tables. It did not help me.