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.
9 Replies
What data type is 'DIM_PARTY_DETAILS'[Date] ?
Br,
JHi 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.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.
In the case, date does not have time, you can use the date. Also how it related to that measure. Also it better to have date calendar for time intelligence functions.
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s.
Refer
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges
Connect on LinkedinHi amitchandak i am trying to calculte the count of users this year minus last year.
i have cretaed a date table : = CALENDAR(MIN(DIM_PARTY_DETAILS[Date]),max(DIM_PARTY_DETAILS[Date]))
i have taken the min and max date from my exsisting tabel and created a calender table and linked the date column from both table in many to one relatioship. Still i am getting the same error.
