Forum Discussion
Parallelperiod function issue
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 Anonymous
You can use Calendar Table / Date Dimension instead of hierarchies, this should remove the error.
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
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.Anonymous,
Could you make a table and bring both the [Date] fields in that you use in the relationship?
Like this:
Take a picture and post it!
Br,
J
