Forum Discussion
How to create columns to classify dates for "date over date to date" comparison of metrics?
Hi toulou, what about using a Period Table, which will make it easier to create the custom periods that you are after?
And then you can use your periods to easily create the calculations you require also?
Super UserHi toulou, what about using a Period Table, which will make it easier to create the custom periods that you are after?
And then you can use your periods to easily create the calculations you require also?
Thank you GilbertQ. This is good solution. I have looked how you set this up and I going to apply this defining the relative dimensions that I need.
I don't need PeriodType at the moment, however, I figuered this might be an interesting dimension also to indicate certain events in your Period Table. In my case this could be certain News Events for example that I then could also include as an additional insight. As a workflow I could set-up an Excel on SharePoint and have people adding events to a date table. This table could be added to the data model then and become a dimension for report and analysis.
I haven't looked into the metric selector yet but I will. It is a nice way to reduce the number of visuals in a Report.
