I am new to using filter parameters in the source URL for power BI queries. I have successfully applied some fixed date filters, e.g. ?$filter = CURDATE ge 2022-01-01T00:00:00Z.

Can someone please help me defining the correct filter parameters for CURDATE greater or equal to (today-90 days), i.e. the filter parameter equivalent to ">= Date.AddDays(DateTime.FixedLocalNow(),-90)"

I need to apply the data in the URL as the source data is huge and server performance is poor whilst I GET the data from the server. Applying the filter in the URL reduces the size of the GET command.

CodePudding user response：

If CURDATE is already configured as a date, you can simply go to Date Filters -> In the Previous:

And then define the period, for instance, previous 90 days: