Forum Discussion
Handling Multiple dates inside visual
Anonymous
To do what you want you have to have role-playing date/time dimensions. You can't achieve it with just one Date table. Sorry. Please create as many date tables as there are dates you want to visualize independently.
Thanks man, I did a little digging on role-playing dimensions and I understood what was missing. It's actually quite simple: since I had relationships with all dates, I was just a matter of using the maintenance end date as legend.
Anonymous
I'll give you a valuable piece of advice (one that one day may save your back if you follow it): Never use columns directly from fact tables to slice and dice data. Always use dimensions. In fact, fact tables should always be hidden from view and only measures should have direct access to their columns.
If you don't follow this advice, you'll have yourself to blame for incorrect figures in your measures in the future.