Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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.   
Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    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's avatar
Anonymous
Not applicable
6 years ago

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.

Mariusz's avatar
Mariusz
Community Champion
6 years ago

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.