Forum Discussion
Help comparing two different periods using SAMEPERIOD()
Hi Ashish! Thank you for your reply.
I understood what you meant, I've tried it and couldn't make it work because if I drag the date dimension I wouldn't be able to use my Text columns. I tried to make a new column in my calendar with the text quarters/years and still couldn't do it.
But your post helped me see that the solution was good, I've made a duplicate of my database and left one of them with just the Full Year values/dates and another one with the quarters. This way I was able to sum the quarters and not have a full year + 4Q in my 4Q visual.
I had to divide things into two visuals for now, one with the comparisons between years and another one with quarters, but I will look for a way to integrate them into a single table/visual that changes if we want to see years or quarters.
So thank you very much!
You are welcome.