Forum Discussion
compare with count previous year
I have a table1 containing customerid, month, presenceboolean. I have a calendartable containing date,month,year. Now I want to visualize a table with columns year, distinctcount customerid and dist...
parry2k
Super User
Super Usernoobtopowerbi I would be very careful using this approach because it is not the best practice and will hit the performance issues on the larger data table. If you want to do the things right way, following best practices, add the date table and use that for all-time intelligence-related measures. The choice is yours. Do it right, or have a short-term solution.
Thank you for your answer. I tried the same using a calendar table containing year,month and year_month. Lin ked by year_month, but that did not help to.
I will dive into the suggestions on date topics. Sometime I will solve this 🙂
ExcelMonkeImpactful Individual
Just remember, it would be best practice to have your date table only contain unique values.