{"id":3196,"date":"2021-04-08T10:43:56","date_gmt":"2021-04-08T17:43:56","guid":{"rendered":"https:\/\/SUMMALAI.COM\/?p=3196"},"modified":"2021-04-08T10:43:58","modified_gmt":"2021-04-08T17:43:58","slug":"how-to-apply-where-clause-in-power-query-in-excel-or-power-bi","status":"publish","type":"post","link":"https:\/\/SUMMALAI.COM\/?p=3196","title":{"rendered":"How to Apply WHERE Clause in Power Query in EXCEL or Power BI"},"content":{"rendered":"\n<p>Go to Query Editor, find the year column, then click drop down to select Number Filters:&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/community.powerbi.com\/t5\/image\/serverpage\/image-id\/94791i34FBC36AAECB78FB\/image-size\/large?v=v2&amp;px=999\" alt=\"w2.PNG\" title=\"w2.PNG\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/community.powerbi.com\/t5\/image\/serverpage\/image-id\/94792i1128F82ED995EBB6\/image-size\/large?v=v2&amp;px=999\" alt=\"w1.PNG\" title=\"w1.PNG\"\/><\/figure>\n\n\n\n<p>The corresponding Power Query will be generated via above action:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/community.powerbi.com\/t5\/image\/serverpage\/image-id\/94793i413C76AC6D5AA79E\/image-size\/large?v=v2&amp;px=999\" alt=\"w3.PNG\" title=\"w3.PNG\"\/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Go to Query Editor, find the year column, then click drop down to select Number Filters:&nbsp; The corresponding Power Query will be generated via above action:<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[10,18,621],"tags":[666],"class_list":["post-3196","post","type-post","status-publish","format-standard","hentry","category-microsoft","category-microsoft-office","category-power-bi","tag-apply-where-clause-in-power-query"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3196","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3196"}],"version-history":[{"count":2,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3196\/revisions"}],"predecessor-version":[{"id":3198,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3196\/revisions\/3198"}],"wp:attachment":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3196"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3196"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3196"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}