Forum Discussion
adding non-parameterized conditions to semantic model incremental refresh
- 1 year ago
Thank you again nilendraFabric -- your thoughtful reply led me to the solution.
Indeed it was separating the two filter statements that was the key, because this allowed me to see the issue was simply with my syntax on the AuditIsDeleted column. It's a bit/boolean column, and as shown in my query snippet above, I was trying to compare it in the filter to a value (0 or 1).
But in fact since PQ sees it as a true/false, no comparison is needed to get a true/false for the criterion -- the column itself is the true/false. So I changed my filter expression to:
= Table.SelectRows(Dimensions_Status, each [AuditPartitionDay] >= RangeStart and [AuditPartitionDay] < RangeEnd and not([AuditIsDeleted]))
and it works as expected now! Isolating that last part into its own statement let me work the syntax until I understood my error. Then I just combined it all back into one filter expression and it's good.
Thank you again for your help. Very much obliged.
Hi markmsc
Hope you are doing well!
Could you please confirm if your query have been resolved the solution provided by nilendraFabric If they have, kindly mark the helpful response and accept it as the solution. This will assist other community members in resolving similar issues more efficiently.
Thank you