Forum Discussion
Relative Date Range in Adobe Analytics
HI Anonymous,
I'd like to suggest you modify your formula to parametrized query with query parameters:
Deep Dive into Query Parameters and Power BI Templates
For example: define two parameters with date type and use them to replace your query formula
{Cube.ApplyParameter, "DateRange", {startDate,endDate}},In addition, you can also consider to use Datetime.Localnow to use local datetime as filter parameter.
Power Query M filter data by Dynamic Date (PQ not DAX) Start of Month
Regards,
Xiaoxin Sheng
HI Anonymous,
I'd like to suggest you modify your formula to parametrized query with query parameters:
Deep Dive into Query Parameters and Power BI Templates
For example: define two parameters with date type and use them to replace your query formula
{Cube.ApplyParameter, "DateRange", {startDate,endDate}},
In addition, you can also consider to use Datetime.Localnow to use local datetime as filter parameter.
Power Query M filter data by Dynamic Date (PQ not DAX) Start of Month
Regards,
Xiaoxin Sheng