Add support for monthly, yearly, or other irregular interval Data View queries
I am using Data Views to produce reports containing data queried with a Monthly or Yearly interval. Currently, I have to make a separate query for each month or year and then append the results together as the query intervals are not constant (ex: months can range from 29-31 days). An easier way to query data with these common intervals using a single query would make generating these reports much easier. Additionally, I am using the Power BI Connector to create the reports so it would also need to be able to handle any added query options.
1
vote
