Yesterday Filter Won't Work in Power Bi Report Builder

mmcarthur — Wed, 10 Aug 2022 19:52:42 GMT

I recently made a Paginated Report from Tables I had in a Power BI Report. Both of my tables have a Yesterday filter applied to them based on their respective date field. When I converted this report to make it a paginated report I copied my query using performance analyzer and built my paginated reports through that query. My question is, will the yesterday date filter code created from the copied query update each day to where it's actually yesterday's date? Or will I need to change this line of code from the query to a code that's something along the line of TODAY()-1? If I need to rewrite the code can I get help on what that would look like? Everything I try brings back an error. This is the line of code I question:

VAR __DS0FilterTable2 =
FILTER(
KEEPFILTERS(VALUES('GLDS Merge'[CompletedDate])),
AND(
'GLDS Merge'[CompletedDate] >= DATE(2022, 8, 9),
'GLDS Merge'[CompletedDate] < DATE(2022, 8, 10)
)
)

Re: Yesterday Filter Won't Work in Power Bi Report Builder

mmcarthur — Wed, 10 Aug 2022 20:39:24 GMT

I found the solution! I was missing a parenthesis before my TODAY()-1 function causing a syntax error. The correct code is (TODAY()-1)

topic Re: Yesterday Filter Won't Work in Power Bi Report Builder in Report Server

Yesterday Filter Won't Work in Power Bi Report Builder

Re: Yesterday Filter Won't Work in Power Bi Report Builder