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