This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
microsoft_power_bi [2022/10/27 13:06] windsor_ai [Increasing the default timeout in Power BI] |
microsoft_power_bi [2023/03/02 13:10] (current) windsor_ai |
||
---|---|---|---|
Line 68: | Line 68: | ||
{{: | {{: | ||
+ | |||
+ | ===== Working with date ranges (absolute and relative) ===== | ||
+ | |||
+ | === Relative date ranges === | ||
+ | |||
+ | When you finish building your query you will see a URL like this: | ||
+ | |||
+ | |||
+ | {{ : | ||
+ | < | ||
+ | |||
+ | Now < | ||
+ | |||
+ | Valid values for relative date ranges are: | ||
+ | |||
+ | * last_1d | ||
+ | * last_3d | ||
+ | * last_7d | ||
+ | * last_14d | ||
+ | * last_28d | ||
+ | * last_30d | ||
+ | * last_90d | ||
+ | * last_180d | ||
+ | * this_month | ||
+ | * last_year | ||
+ | |||
+ | You can change the values accordingly to change the relative date range. | ||
+ | |||
+ | === Absolute date ranges === | ||
+ | |||
+ | To work with absolute (fixed) date ranges you can select a date range in the date range picker | ||
+ | |||
+ | |||
+ | {{ : | ||
+ | |||
+ | |||
+ | < | ||
+ | |||
+ | Will load the date range < | ||
+ | |||
+ | To only set a start date and default to todays date as end date you simply just remove the date_to from the URL. The query then would look like this: | ||
+ | |||
+ | < |