Skip to main content

Power BI

New

Add Not in Clause in Power query

Vote (1) Share
Buddhi Gupta's profile image

Buddhi Gupta on 13 Dec 2023 18:41:05

Hi


Currently we have to use List.Contains as input for IN clause Power query; however, for complex logic it becomes cumbersome to read and understand. It will be better to implement IN or NOT IN clauses similar to SQL interface and should be able to pass back to Data source.