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.

     

     

tex628's avatar
tex628
Community Champion
6 years ago

What data type is 'DIM_PARTY_DETAILS'[Date] ?

Br,
J

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

     

    i evne created a seperate date table and marked the table as date table and used this column for calculation still throws error