Forum Discussion
Dynamically Filtering TRUNC(SYSDATE) - 1 Without Breaking Query Folding
I have read several questions related to filtering dates without breaking query folding, but none seem to help with my issue. In Oracle I would write: DateColumn BETWEEN TRUNC(SYSDATE, 'YYYY')...
not exactly clear what date range you are trying to achieve. Can you specify the filters in the Power Query UI? If you do that then the chances of folding are higher.
All of the prior year and YTD not including the current day is the end goal. Native UI in Power Query does not allow me to remove the current day dynamically. I can easily filter the prior year and YTD as one step and then have tried adding another step to then filter Is Not Latest; however, if there is no data yet reported for the current day it then filters out yesterday. If I am missing something please let me know. Thank you!
Is this a Direct Query or Import Mode data source? If it is import mode I would filter the "incomplete day" out in the UI.