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.
Mariusz
Community Champion
Community ChampionHi Anonymous
You can use Calendar Table / Date Dimension instead of hierarchies, this should remove the error.
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
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.