Forum Discussion
Parallelperiod function issue
Hi All, i am unable to use the parallel period function because the .[Date] is not working. Please find the error image.
Hi Anonymous
When you use Date Dimension / Calendar Table you don't need to refer to a dates hierarchy ( [date].[date] ) anymore, you just use 'CalendarTable'[Date], If you need to refer to the month, for example, then you add an extra column into you dimension representing a month and refer to this column.
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
hi Mariusz
i did create a calender table then linked the date column from both table in many to one relationship still i am getting the same error.
Previousyear, previousmonth, previousquarter and parrallelperiod all these are not working