search

sql-bi / Bravo

Bravo for Power BI
MIT License
347 stars 89 forks source link

Allow a "+/- year from today" option for - Manage Dates / Interval / First/Last Year #554

Open mscottsewell opened 1 year ago

mscottsewell commented 1 year ago

The feature request

Manage Dates / Interval / First/Last Year we have roughly 2 options - either Fixed Year or dynamic based on data. Fixed requires updates in the future. Dynamic based on data breaks if the report is Direct Query. (The service cannot schedule refreshes where there is a calculated value based on direct query data.)

Proposed solution

A 3rd option would be to give a dynamic window of Year(Today()) +/- "X" # of years to calculate the start/end years. This would always include the current year minus one or two (or whatever # of years) as the starting year - and plus one or two (or whatever # of years) as the end date in the future.

Additional context

No response

marcosqlbi commented 1 year ago

Hi Scott, nice to hear from you! It's a good idea - we do not cover too many use cases for DirectQuery in our daily work, so this kind of suggestions is very welcome. We'll consider it for a future version (we have to evaluate the impact on UI, but the first step is triage - done!).