Parallelperiod function issue

[Anonymous]

Hi All,

i am unable to use the parallel period function because the .[Date] is not working. Please find the error image. 

[amitchandak]

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 Linkedin

[Anonymous]

Hi @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.

[Mariusz]

Hi @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.

[Anonymous]

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.

[tex628]

@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

[Mariusz · Accepted solution]

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]

Previousyear, previousmonth, previousquarter and parrallelperiod all these are not working

[tex628]

What data type is 'DIM_PARTY_DETAILS'[Date] ?

Br,
J

[Anonymous]

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