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
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.