Forum Discussion
DirectQuery "[Posting Date] = latest" issue
Here is the answer:
https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about
Do not use the relative data filtering in Query Editor. It's possible to define relative date filtering in Query Editor. For example, to filter to the rows where the date is in the last 14 days.
However, this will be translated into a filter based on the fixed date, as at the time the query was authored. This can be seen from viewing the native query.
Here is the answer:
https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about
Do not use the relative data filtering in Query Editor. It's possible to define relative date filtering in Query Editor. For example, to filter to the rows where the date is in the last 14 days.
However, this will be translated into a filter based on the fixed date, as at the time the query was authored. This can be seen from viewing the native query.