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...
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 🙂
ExcelMonke
Impactful Individual
Impactful IndividualJust remember, it would be best practice to have your date table only contain unique values.