Status:
New
Simplify time intelligence functions to work on single data sets without a date table
Tableau works its magic with dates just based on date fields in a set. Power BI workbooks and Power BI designer would be super simplified if there was an inherent calendar built into the product base...
I have to agree with Angel. The time spent creating a time dimension, and wiring it up in cubes/models is really redundant work that should be part of the product. Any Date or DateTime column implies a relationship with a robust date dimension. Given that, a whole set of common date-based aggregates and calculations could be implied as well, (MTD, YTD, YOY, variances, etc.), without any coding needed by the user/cube designer. I have a whole set of code templates and code generators for SQL and MDX cubes for date calculations and have done something similar in DAX as well, leveraging what Marco Russo has published on SQLBI.com.
