Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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)
)
)
Solved! Go to Solution.
I found the solution! I was missing a parenthesis before my TODAY()-1 function causing a syntax error. The correct code is (TODAY()-1)
I found the solution! I was missing a parenthesis before my TODAY()-1 function causing a syntax error. The correct code is (TODAY()-1)
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
17 | |
16 | |
3 | |
2 | |
2 |