{"id":2985,"date":"2024-12-02T09:49:38","date_gmt":"2024-12-02T09:49:38","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/power-query-chinh-sua-truy-van\/"},"modified":"2024-12-02T09:49:38","modified_gmt":"2024-12-02T09:49:38","slug":"power-query-chinh-sua-truy-van","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/power-query-chinh-sua-truy-van\/","title":{"rendered":"Power Query \u2013 Ch\u1ec9nh s\u1eeda truy v\u1ea5n"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-h4k0Fa0I#1\">\n<p><em><span style=\"font-weight: 400\">Trong ph\u1ea7n n\u00e0y c\u1ee7a lo\u1ea1t b\u00e0i vi\u1ebft v\u1ec1 Power Query, ch\u00fang ta s\u1ebd c\u00f9ng t\u00ecm hi\u1ec3u <a href=\"http:\/\/blog.ezworkapp.com\/power-query-chinh-sua-truy-van.html\"><strong>c\u00e1ch ch\u1ec9nh s\u1eeda truy v\u1ea5n Power Query.<\/strong><\/a> \u1ede m\u1ed9t b\u00e0i vi\u1ebft tr\u01b0\u1edbc m\u00ecnh \u0111\u00e3 h\u01b0\u1edbng d\u1eabn s\u01a1 qua, nh\u01b0ng b\u00e2y gi\u1edd <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd gi\u00fap b\u1ea1n \u0111i s\u00e2u h\u01a1n nhi\u1ec1u.\u00a0<\/span><\/em><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-674d82b114057\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/power-query-chinh-sua-truy-van.html#Tai_xuong_cac_tep_mau\" title=\"T\u1ea3i xu\u1ed1ng c\u00e1c t\u1ec7p m\u1eabu\">T\u1ea3i xu\u1ed1ng c\u00e1c t\u1ec7p m\u1eabu<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/power-query-chinh-sua-truy-van.html#Chinh_sua_mot_truy_van_hien_co\" title=\"Ch\u1ec9nh s\u1eeda m\u1ed9t truy v\u1ea5n hi\u1ec7n c\u00f3\">Ch\u1ec9nh s\u1eeda m\u1ed9t truy v\u1ea5n hi\u1ec7n c\u00f3<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/power-query-chinh-sua-truy-van.html#Mo_Power_Query\" title=\"M\u1edf Power Query\">M\u1edf Power Query<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/power-query-chinh-sua-truy-van.html#Chon_mot_truy_van_de_chinh_sua\" title=\"Ch\u1ecdn m\u1ed9t truy v\u1ea5n \u0111\u1ec3 ch\u1ec9nh s\u1eeda\">Ch\u1ecdn m\u1ed9t truy v\u1ea5n \u0111\u1ec3 ch\u1ec9nh s\u1eeda<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/power-query-chinh-sua-truy-van.html#Close_Load\" title=\"Close &amp; Load\">Close &amp; Load<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/power-query-chinh-sua-truy-van.html#Dong_ma_khong_luu_thay_doi\" title=\"\u0110\u00f3ng m\u00e0 kh\u00f4ng l\u01b0u thay \u0111\u1ed5i\">\u0110\u00f3ng m\u00e0 kh\u00f4ng l\u01b0u thay \u0111\u1ed5i<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/power-query-chinh-sua-truy-van.html#Chinh_sua_cac_buoc\" title=\"Ch\u1ec9nh s\u1eeda c\u00e1c b\u01b0\u1edbc\">Ch\u1ec9nh s\u1eeda c\u00e1c b\u01b0\u1edbc<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/power-query-chinh-sua-truy-van.html#Cai_dat_co_ban\" title=\"C\u00e0i \u0111\u1eb7t c\u01a1 b\u1ea3n\">C\u00e0i \u0111\u1eb7t c\u01a1 b\u1ea3n<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/power-query-chinh-sua-truy-van.html#Them_chen_xoa_va_di_chuyen_cac_buoc\" title=\"Th\u00eam, ch\u00e8n, x\u00f3a v\u00e0 di chuy\u1ec3n c\u00e1c b\u01b0\u1edbc\">Th\u00eam, ch\u00e8n, x\u00f3a v\u00e0 di chuy\u1ec3n c\u00e1c b\u01b0\u1edbc<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/power-query-chinh-sua-truy-van.html#Ma_M_trong_thanh_cong_thuc_Trinh_chinh_sua_nang_cao\" title=\"M\u00e3 M trong thanh c\u00f4ng th\u1ee9c &amp; Tr\u00ecnh ch\u1ec9nh s\u1eeda n\u00e2ng cao\">M\u00e3 M trong thanh c\u00f4ng th\u1ee9c &amp; Tr\u00ecnh ch\u1ec9nh s\u1eeda n\u00e2ng cao<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/power-query-chinh-sua-truy-van.html#Tai_vao_Excel\" title=\"T\u1ea3i v\u00e0o Excel\">T\u1ea3i v\u00e0o Excel<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Tai_xuong_cac_tep_mau\"><\/span><b>T\u1ea3i xu\u1ed1ng c\u00e1c t\u1ec7p m\u1eabu<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">N\u1ebfu nh\u00ecn c\u00e1c v\u00ed d\u1ee5 \u0111\u01b0\u1ee3c c\u1eaft ra b\u00ean d\u01b0\u1edbi b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 hi\u1ec3u n\u00f3, nh\u01b0ng b\u1ea1n s\u1ebd l\u01b0u gi\u1eef th\u00f4ng tin t\u1ed1t h\u01a1n nhi\u1ec1u n\u1ebfu b\u1ea1n t\u1ea3i c\u00e1c v\u00ed d\u1ee5 v\u1ec1 v\u00e0 th\u1ef1c h\u00e0nh c\u00f9ng m\u00ecnh.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Nh\u1ea5p v\u00e0o <a href=\"https:\/\/drive.google.com\/file\/d\/1LkCuZ2XkFnOSKgtqYR4y3VllpSn1XSlf\/view\"><strong>Downloads<\/strong><\/a> \u0111\u1ec3 t\u1ea3i nh\u00e9!<\/span><\/p>\n<p><span style=\"font-weight: 400\">T\u1ea5t c\u1ea3 c\u00e1c v\u00ed d\u1ee5 trong b\u00e0i vi\u1ebft n\u00e0y s\u1eed d\u1ee5ng <\/span><b>Example 7 \u2013 Edit Queries.xlsx<\/b><span style=\"font-weight: 400\"> t\u1eeb b\u1ea3n t\u1ea3i xu\u1ed1ng. N\u00f3 l\u00e0 m\u1ed9t s\u1ed5 l\u00e0m vi\u1ec7c Excel \u0111\u00e3 ch\u1ee9a m\u1ed9t s\u1ed1 truy v\u1ea5n c\u01a1 b\u1ea3n.<\/span><\/p>\n<p><span style=\"font-weight: 400\">B\u00e2y gi\u1edd th\u00ec m\u1edf t\u1ec7p l\u00ean v\u00e0 b\u1eaft \u0111\u1ea7u th\u00f4i.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Chinh_sua_mot_truy_van_hien_co\"><\/span><b>Ch\u1ec9nh s\u1eeda m\u1ed9t truy v\u1ea5n hi\u1ec7n c\u00f3<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">C\u0169ng nh\u01b0 nhi\u1ec1u t\u00ednh n\u0103ng kh\u00e1c c\u1ee7a <a href=\"http:\/\/blog.ezworkapp.com\/power-query-la-gi-tai-sao-can-hoc-power-query.html\"><strong>Power Query<\/strong><\/a>, c\u00f3 nhi\u1ec1u c\u00e1ch \u0111\u1ec3 truy c\u1eadp v\u00e0o c\u00f9ng m\u1ed9t h\u00e0nh \u0111\u1ed9ng. Vi\u1ec7c m\u1edf Power Query \u0111\u1ec3 ch\u1ec9nh s\u1eeda m\u1ed9t truy v\u1ea5n hi\u1ec7n c\u00f3 c\u0169ng th\u1ebf, c\u00f3 v\u00f4 s\u1ed1 c\u00e1ch \u0111\u1ec3 th\u1ef1c hi\u1ec7n. M\u00ecnh s\u1ebd tr\u00ecnh b\u00e0y ng\u1eafn g\u1ecdn nh\u1eefng \u0111i\u1ec1u ph\u1ed5 bi\u1ebfn nh\u1ea5t b\u00ean d\u01b0\u1edbi, m\u1eb7c d\u00f9 ch\u00fang ta ch\u1ec9 th\u1ef1c s\u1ef1 c\u1ea7n bi\u1ebft m\u1ed9t ho\u1eb7c hai.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Mo_Power_Query\"><\/span><b>M\u1edf Power Query<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><b>Queries &amp; Connections<\/b><span style=\"font-weight: 400\"> \u2013 Nh\u1ea5p \u0111\u00fap<\/span><\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-227.gif\" title=\"ex101_92019-nho-227\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><span style=\"font-weight: 400\">Ph\u01b0\u01a1ng ph\u00e1p d\u1ec5 nh\u1ea5t l\u00e0 nh\u1ea5p v\u00e0o <\/span><b>Data -&gt; Queries &amp; Connections.<\/b><\/p>\n<figure id=\"attachment_34659\" aria-describedby=\"caption-attachment-34659\" style=\"width: 777px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34659 size-full\" title=\"1- power query - ch\u1ec9nh s\u1eeda truy v\u1ea5n\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h1-8.png\" alt=\"1- power query - ch\u1ec9nh s\u1eeda truy v\u1ea5n\" width=\"777\" height=\"139\"><figcaption id=\"caption-attachment-34659\" class=\"wp-caption-text\">1- power query \u2013 ch\u1ec9nh s\u1eeda truy v\u1ea5n<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">C\u1eeda s\u1ed5 <\/span><span style=\"font-weight: 400\">Queries &amp; Connections<\/span><span style=\"font-weight: 400\"> s\u1ebd m\u1edf ra, ch\u1ec9 c\u1ea7n nh\u1ea5p \u0111\u00fap v\u00e0o t\u00ean c\u1ee7a truy v\u1ea5n.<\/span><\/p>\n<figure id=\"attachment_34660\" aria-describedby=\"caption-attachment-34660\" style=\"width: 381px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34660 size-full\" title=\"2- power query - ch\u1ec9nh s\u1eeda truy v\u1ea5n\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h2-7.png\" alt=\"2- power query - ch\u1ec9nh s\u1eeda truy v\u1ea5n\" width=\"381\" height=\"307\"><figcaption id=\"caption-attachment-34660\" class=\"wp-caption-text\">2- power query \u2013 ch\u1ec9nh s\u1eeda truy v\u1ea5n<\/figcaption><\/figure>\n<p><b>Queries &amp; Connections \u2013 Nh\u1ea5p chu\u1ed9t ph\u1ea3i \u2013 ch\u1ecdn Edit<\/b><\/p>\n<p><span style=\"font-weight: 400\">Trong c\u1eeda s\u1ed5 <\/span><span style=\"font-weight: 400\">Queries &amp; Connections<\/span><span style=\"font-weight: 400\">, ch\u00fang ta c\u00f3 th\u1ec3 nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o truy v\u1ea5n v\u00e0 ch\u1ecdn ch\u1ec9nh s\u1eeda(edit).<\/span><\/p>\n<figure id=\"attachment_34661\" aria-describedby=\"caption-attachment-34661\" style=\"width: 379px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34661 size-full\" title=\"3- power query - ch\u1ec9nh s\u1eeda truy v\u1ea5n\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h3-7.png\" alt=\"3- power query - ch\u1ec9nh s\u1eeda truy v\u1ea5n\" width=\"379\" height=\"359\"><figcaption id=\"caption-attachment-34661\" class=\"wp-caption-text\">3- power query \u2013 ch\u1ec9nh s\u1eeda truy v\u1ea5n<\/figcaption><\/figure>\n<p><b>Queries &amp; Connections \u2013 Di chu\u1ed9t ch\u1ecdn Edit<\/b><\/p>\n<p><span style=\"font-weight: 400\">Khi di chu\u1ed9t qua m\u1ed9t truy v\u1ea5n (kh\u00f4ng nh\u1ea5p, ch\u1ec9 di chu\u1ed9t), Excel s\u1ebd hi\u1ec3n th\u1ecb t\u00f3m t\u1eaft truy v\u1ea5n. Nh\u1ea5p v\u00e0o t\u00f9y ch\u1ecdn Edit \u1edf d\u01b0\u1edbi c\u00f9ng.<\/span><\/p>\n<figure id=\"attachment_34662\" aria-describedby=\"caption-attachment-34662\" style=\"width: 830px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34662 size-full\" title=\"4- power query - ch\u1ec9nh s\u1eeda truy v\u1ea5n\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h4-8.png\" alt=\"4- power query - ch\u1ec9nh s\u1eeda truy v\u1ea5n\" width=\"830\" height=\"553\"><figcaption id=\"caption-attachment-34662\" class=\"wp-caption-text\">4- power query \u2013 ch\u1ec9nh s\u1eeda truy v\u1ea5n<\/figcaption><\/figure>\n<p><b>\u00a0Kh\u1edfi ch\u1ea1y Power Query Editor<\/b><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u00e3 \u0111\u01b0\u1ee3c h\u01b0\u1edbng d\u00e3n c\u1ee5 th\u1ec3 trong b\u00e0i vi\u1ebft <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-dua-du-lieu-ve-dang-chuan-voi-power-query-trong-excel.html\"><strong>Chu\u1ea9n h\u00f3a d\u1eef li\u1ec7u b\u1eb1ng Power Query<\/strong><\/a>. M\u1ed9t ph\u01b0\u01a1ng ph\u00e1p kh\u00e1c l\u00e0 m\u1edf tr\u00ecnh so\u1ea1n th\u1ea3o Power Query m\u00e0 kh\u00f4ng c\u1ea7n ch\u1ecdn m\u1ed9t truy v\u1ea5n c\u1ee5 th\u1ec3<\/span><\/p>\n<p><span style=\"font-weight: 400\">Nh\u1ea5p v\u00e0o <\/span><span style=\"font-weight: 400\">\u00a0<\/span><b>Data -&gt; Get Data -&gt; Launch Power Query Editor<\/b><span style=\"font-weight: 400\">.<\/span><\/p>\n<figure id=\"attachment_34663\" aria-describedby=\"caption-attachment-34663\" style=\"width: 592px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34663 size-full\" title=\"5- power query - ch\u1ec9nh s\u1eeda truy v\u1ea5n\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h5-8.png\" alt=\"5- power query - ch\u1ec9nh s\u1eeda truy v\u1ea5n\" width=\"592\" height=\"511\"><figcaption id=\"caption-attachment-34663\" class=\"wp-caption-text\">5- power query \u2013 ch\u1ec9nh s\u1eeda truy v\u1ea5n<\/figcaption><\/figure>\n<p><b>Query Tools<\/b><\/p>\n<p><span style=\"font-weight: 400\">V\u1eabn c\u00f2n m\u1ed9t ph\u01b0\u01a1ng ph\u00e1p n\u1eefa \u0111\u1ec3 b\u1ea1n th\u1eed, h\u00e3y ch\u1ecdn b\u1ea5t k\u1ef3 \u00f4 n\u00e0o trong b\u1ea3ng truy v\u1ea5n. M\u1ed9t d\u1ea3i Query m\u1edbi s\u1ebd xu\u1ea5t hi\u1ec7n. Nh\u1ea5p v\u00e0o <\/span><b>Query -&gt; Edit<\/b><span style=\"font-weight: 400\">.<\/span><\/p>\n<figure id=\"attachment_34664\" aria-describedby=\"caption-attachment-34664\" style=\"width: 849px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34664 size-full\" title=\"6- power query - ch\u1ec9nh s\u1eeda truy v\u1ea5n\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h6-8.png\" alt=\"6- power query - ch\u1ec9nh s\u1eeda truy v\u1ea5n\" width=\"849\" height=\"138\"><figcaption id=\"caption-attachment-34664\" class=\"wp-caption-text\">6- power query \u2013 ch\u1ec9nh s\u1eeda truy v\u1ea5n<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Chon_mot_truy_van_de_chinh_sua\"><\/span><b>Ch\u1ecdn m\u1ed9t truy v\u1ea5n \u0111\u1ec3 ch\u1ec9nh s\u1eeda<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">Khi tr\u00ecnh ch\u1ec9nh s\u1eeda Power Query m\u1edf ra, ch\u00fang ta c\u00f3 th\u1ec3 ch\u1ec9nh s\u1eeda b\u1ea5t k\u1ef3 truy v\u1ea5n n\u00e0o t\u1ed3n t\u1ea1i trong s\u1ed5 l\u00e0m vi\u1ec7c. B\u1ea1n c\u00f3 th\u1ec3 m\u1edf r\u1ed9ng danh s\u00e1ch truy v\u1ea5n b\u1eb1ng c\u00e1ch nh\u1ea5p v\u00e0o m\u0169i t\u00ean \u1edf tr\u00ean c\u00f9ng b\u00ean tr\u00e1i c\u1ee7a b\u1ea3n xem tr\u01b0\u1edbc d\u1eef li\u1ec7u.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Danh s\u00e1ch truy v\u1ea5n s\u1ebd m\u1edf ra.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Nh\u1ea5p v\u00e0o b\u1ea5t k\u1ef3 truy v\u1ea5n ri\u00eang l\u1ebb n\u00e0o \u0111\u1ec3 k\u00edch ho\u1ea1t truy v\u1ea5n \u0111\u00f3 \u0111\u1ec3 xem ho\u1eb7c ch\u1ec9nh s\u1eeda.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Close_Load\"><\/span><span style=\"font-weight: 400\">Close &amp; Load<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Trong r\u1ea5t nhi\u1ec1u c\u00e1c b\u00e0i trong lo\u1ea1t b\u00e0i v\u1ec1 Power Query n\u00e0y, ch\u00fang ta ch\u1ec9 s\u1eed d\u1ee5ng <strong>Close &amp; Load<\/strong> khi t\u1ea1o c\u00e1c truy v\u1ea5n. Ch\u00fang ta ch\u1ec9 c\u1ea7n t\u1ea3i c\u00e1c truy v\u1ea5n \u0111\u01a1n l\u1ebb v\u00e0o Excel. Tuy nhi\u00ean b\u1ea1n l\u01b0u \u00fd r\u1eb1ng Close &amp; Load \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng cho t\u1ea5t c\u1ea3 c\u00e1c truy v\u1ea5n trong c\u1eeda s\u1ed5 l\u00e0m vi\u1ec7c. V\u00ec v\u1eady, n\u1ebfu b\u1ea1n th\u1ef1c hi\u1ec7n thay \u0111\u1ed5i cho nhi\u1ec1u truy v\u1ea5n, sau \u0111\u00f3 c\u1eadp nh\u1eadt v\u1edbi Close &amp; Load th\u00ec t\u1ea5t c\u1ea3 c\u00e1c truy v\u1ea5n s\u1ebd \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt, kh\u00f4ng ch\u1ec9 nh\u1eefng truy v\u1ea5n \u0111ang ho\u1ea1t \u0111\u1ed9ng.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Dong_ma_khong_luu_thay_doi\"><\/span><b>\u0110\u00f3ng m\u00e0 kh\u00f4ng l\u01b0u thay \u0111\u1ed5i<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">Sau khi ch\u1ec9nh s\u1eeda truy v\u1ea5n, ch\u00fang ta c\u00f3 th\u1ec3 quy\u1ebft \u0111\u1ecbnh r\u1eb1ng ch\u00fang ta kh\u00f4ng mu\u1ed1n t\u1ea3i c\u00e1c thay \u0111\u1ed5i v\u00e0o Excel. V\u1eady \u0111\u1ec3 lo\u1ea1i b\u1ecf c\u00e1c thay \u0111\u1ed5i \u0111\u00f3, b\u1ea1n h\u00e3y nh\u1ea5p v\u00e0o <\/span><b>File -&gt; Discard and Close<\/b><\/p>\n<figure id=\"attachment_34666\" aria-describedby=\"caption-attachment-34666\" style=\"width: 1029px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34666 size-full\" title=\"7- ch\u1ec9nh s\u1eeda truy v\u1ea5n power query\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h7-7.png\" alt=\"7- ch\u1ec9nh s\u1eeda truy v\u1ea5n power query\" width=\"1029\" height=\"442\"><figcaption id=\"caption-attachment-34666\" class=\"wp-caption-text\">7- ch\u1ec9nh s\u1eeda truy v\u1ea5n power query<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Ngo\u00e0i ra, b\u1ea1n c\u00f3 th\u1ec3 nh\u1ea5p v\u00e0o n\u00fat \u0111\u00f3ng [X]\u00a0 (tr\u00ean c\u00f9ng b\u00ean ph\u1ea3i c\u1ee7a c\u1eeda s\u1ed5). S\u1ebd c\u00f3 m\u1ed9t c\u1eeda s\u1ed5 x\u00e1c nh\u1eadn \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o ch\u00fang ta kh\u00f4ng nh\u1ea5p nh\u1ea7m v\u00e0o n\u00f3.<\/span><\/p>\n<figure id=\"attachment_34667\" aria-describedby=\"caption-attachment-34667\" style=\"width: 1029px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34667 size-full\" title=\"8- ch\u1ec9nh s\u1eeda truy v\u1ea5n power query\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h8-7.png\" alt=\"8- ch\u1ec9nh s\u1eeda truy v\u1ea5n power query\" width=\"1029\" height=\"442\"><figcaption id=\"caption-attachment-34667\" class=\"wp-caption-text\">8- ch\u1ec9nh s\u1eeda truy v\u1ea5n power query<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Chinh_sua_cac_buoc\"><\/span><b>Ch\u1ec9nh s\u1eeda c\u00e1c b\u01b0\u1edbc<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">B\u00e2y gi\u1edd ch\u00fang ta \u0111ang \u1edf trong Power Query v\u00e0 c\u00f3 th\u1ec3 di chuy\u1ec3n t\u1ef1 do gi\u1eefa c\u00e1c truy v\u1ea5n v\u00e0 \u0111\u00e3 s\u1eb5n s\u00e0ng \u0111\u1ec3 b\u1eaft \u0111\u1ea7u ch\u1ec9nh s\u1eeda c\u00e1c b\u01b0\u1edbc ri\u00eang l\u1ebb. Trong ph\u1ea7n n\u00e0y, ch\u00fang ta s\u1ebd l\u00e0m vi\u1ec7c v\u1edbi t\u1ec7p v\u00ed d\u1ee5 \u0111\u1ec3 s\u1eeda \u0111\u1ed5i c\u00e1c ph\u00e9p bi\u1ebfn \u0111\u1ed5i hi\u1ec7n c\u00f3.<\/span><\/p>\n<p><span style=\"font-weight: 400\">B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng m\u1ed9t trong c\u00e1c ph\u01b0\u01a1ng ph\u00e1p tr\u00ean \u0111\u1ec3 m\u1edf Power Query v\u00e0 b\u1eaft \u0111\u1ea7u ch\u1ec9nh s\u1eeda m\u1ed9t s\u1ed1 chuy\u1ec3n \u0111\u1ed5i.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cai_dat_co_ban\"><\/span><b>C\u00e0i \u0111\u1eb7t c\u01a1 b\u1ea3n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">Nh\u01b0 ch\u00fang ta \u0111\u00e3 th\u1ea5y trong m\u1ed9t b\u00e0i vi\u1ebft tr\u01b0\u1edbc, bi\u1ec3u t\u01b0\u1ee3ng b\u00e1nh r\u0103ng t\u1ed3n t\u1ea1i b\u00ean c\u1ea1nh nhi\u1ec1u b\u01b0\u1edbc. Nh\u1ea5p v\u00e0o n\u00f3 s\u1ebd hi\u1ec3n th\u1ecb c\u1eeda s\u1ed5 t\u00f9y ch\u1ecdn cho b\u01b0\u1edbc c\u1ee5 th\u1ec3 \u0111\u00f3.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Ch\u1ecdn truy v\u1ea5n <\/span><b>Top Customers<\/b><span style=\"font-weight: 400\">, sau \u0111\u00f3 nh\u1ea5p v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng b\u00e1nh r\u0103ng b\u00ean c\u1ea1nh b\u01b0\u1edbc <\/span><b>Keep First Rows.<\/b><\/p>\n<figure id=\"attachment_34668\" aria-describedby=\"caption-attachment-34668\" style=\"width: 502px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34668 size-full\" title=\"9- ch\u1ec9nh s\u1eeda truy v\u1ea5n power query\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h9-6.png\" alt=\"9- ch\u1ec9nh s\u1eeda truy v\u1ea5n power query\" width=\"502\" height=\"306\"><figcaption id=\"caption-attachment-34668\" class=\"wp-caption-text\">9- ch\u1ec9nh s\u1eeda truy v\u1ea5n power query<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">C\u1eeda s\u1ed5 Keep Top Rows s\u1ebd m\u1edf ra. Truy v\u1ea5n hi\u1ec7n \u0111ang hi\u1ec3n th\u1ecb 5 kh\u00e1ch h\u00e0ng, h\u00e3y thay \u0111\u1ed5i th\u00e0nh 3 v\u00e0 nh\u1ea5p v\u00e0o OK.<\/span><\/p>\n<figure id=\"attachment_34669\" aria-describedby=\"caption-attachment-34669\" style=\"width: 519px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34669 size-full\" title=\"10- ch\u1ec9nh s\u1eeda truy v\u1ea5n power query\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h10-6.png\" alt=\"10- ch\u1ec9nh s\u1eeda truy v\u1ea5n power query\" width=\"519\" height=\"185\"><figcaption id=\"caption-attachment-34669\" class=\"wp-caption-text\">10- ch\u1ec9nh s\u1eeda truy v\u1ea5n power query<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Them_chen_xoa_va_di_chuyen_cac_buoc\"><\/span><b>Th\u00eam, ch\u00e8n, x\u00f3a v\u00e0 di chuy\u1ec3n c\u00e1c b\u01b0\u1edbc<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">Ch\u1ecdn truy v\u1ea5n <\/span><b>TopCustomers<\/b><span style=\"font-weight: 400\"> v\u00e0 nh\u1ea5p v\u00e0o b\u01b0\u1edbc \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 <\/span><b>Calculated End of Month<\/b><span style=\"font-weight: 400\">. B\u1ea3n xem tr\u01b0\u1edbc d\u1eef li\u1ec7u hi\u1ec3n th\u1ecb t\u1ea5t c\u1ea3 c\u00e1c b\u01b0\u1edbc cho \u0111\u1ebfn khi k\u1ebft th\u00fac l\u1ef1a ch\u1ecdn hi\u1ec7n t\u1ea1i.<\/span><\/p>\n<figure id=\"attachment_34672\" aria-describedby=\"caption-attachment-34672\" style=\"width: 1029px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34672 size-full\" title=\"13- ch\u1ec9nh s\u1eeda truy v\u1ea5n power query\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h13-4.png\" alt=\"13- ch\u1ec9nh s\u1eeda truy v\u1ea5n power query\" width=\"1029\" height=\"516\"><figcaption id=\"caption-attachment-34672\" class=\"wp-caption-text\">13- ch\u1ec9nh s\u1eeda truy v\u1ea5n power query<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 ch\u00e8n th\u00eam m\u1ed9t b\u01b0\u1edbc, h\u00e3y ch\u1ecdn m\u1ed9t b\u01b0\u1edbc hi\u1ec7n c\u00f3, sau \u0111\u00f3 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p bi\u1ebfn \u0111\u1ed5i m\u00e0 ch\u00fang ta mu\u1ed1n \u00e1p d\u1ee5ng ti\u1ebfp theo.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Nh\u1ea5p v\u00e0o menu th\u1ea3 xu\u1ed1ng c\u1ee7a c\u1ed9t Date v\u00e0 ch\u1ec9 ch\u1ecdn ng\u00e0y 31 th\u00e1ng 1 n\u0103m 2019 (t\u00f9y thu\u1ed9c v\u00e0o \u0111\u1ecbnh d\u1ea1ng ng\u00e0y \u0111\u1ecba ph\u01b0\u01a1ng c\u1ee7a b\u1ea1n, n\u00f3 c\u00f3 th\u1ec3 h\u01a1i kh\u00e1c \u0111\u1ed1i v\u1edbi b\u1ea1n).<\/span><\/p>\n<figure id=\"attachment_34673\" aria-describedby=\"caption-attachment-34673\" style=\"width: 386px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34673 size-full\" title=\"14- ch\u1ec9nh s\u1eeda truy v\u1ea5n power query\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h14-3.png\" alt=\"14- ch\u1ec9nh s\u1eeda truy v\u1ea5n power query\" width=\"386\" height=\"408\"><figcaption id=\"caption-attachment-34673\" class=\"wp-caption-text\">14- ch\u1ec9nh s\u1eeda truy v\u1ea5n power query<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">V\u1eady l\u00e0 m\u1ed9t b\u01b0\u1edbc m\u1edbi \u0111\u00e3 \u0111\u01b0\u1ee3c th\u00eam v\u00e0o gi\u1eefa c\u00e1c b\u01b0\u1edbc.<\/span><\/p>\n<figure id=\"attachment_34674\" aria-describedby=\"caption-attachment-34674\" style=\"width: 274px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34674 size-full\" title=\"15- ch\u1ec9nh s\u1eeda truy v\u1ea5n power query\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h15-4.png\" alt=\"15- ch\u1ec9nh s\u1eeda truy v\u1ea5n power query\" width=\"274\" height=\"214\"><figcaption id=\"caption-attachment-34674\" class=\"wp-caption-text\">15- ch\u1ec9nh s\u1eeda truy v\u1ea5n power query<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Ti\u1ebfp t\u1ee5c nh\u1ea5p qua c\u00e1c b\u01b0\u1edbc kh\u00e1c \u0111\u1ec3 xem c\u00e1c ph\u00e9p bi\u1ebfn \u0111\u1ed5i:<\/span><\/p>\n<p><span style=\"font-weight: 400\">Khi b\u1ea1n thay \u0111\u1ed5i, di chuy\u1ec3n ho\u1eb7c ch\u00e8n c\u00e1c b\u01b0\u1edbc, \u0111i\u1ec1u \u0111\u00f3 c\u00f3 th\u1ec3 g\u00e2y ra s\u1ef1 c\u1ed1 sau n\u00e0y trong truy v\u1ea5n b\u1edfi v\u00ec nh\u1eefng thay \u0111\u1ed5i b\u1ea1n th\u1ef1c hi\u1ec7n s\u1ebd kh\u00f4ng chuy\u1ec3n qua c\u00e1c b\u01b0\u1edbc ti\u1ebfp theo m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c. M\u00ecnh s\u1ebd cho ba\u0323n xem.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Nh\u1ea5p v\u00e0o b\u01b0\u1edbc <\/span><b>Removed Columns<\/b><span style=\"font-weight: 400\">. Thay \u0111\u1ed5i ti\u00eau \u0111\u1ec1 c\u1ee7a c\u1ed9t <\/span><b>Date<\/b><span style=\"font-weight: 400\"> th\u00e0nh <\/span><b>Month end<\/b><span style=\"font-weight: 400\">.<\/span><span style=\"font-weight: 400\">.<\/span><\/p>\n<figure id=\"attachment_34675\" aria-describedby=\"caption-attachment-34675\" style=\"width: 1026px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34675 size-full\" title=\"16- ch\u1ec9nh s\u1eeda truy v\u1ea5n power query\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h16-4.png\" alt=\"16- ch\u1ec9nh s\u1eeda truy v\u1ea5n power query\" width=\"1026\" height=\"386\"><figcaption id=\"caption-attachment-34675\" class=\"wp-caption-text\">16- ch\u1ec9nh s\u1eeda truy v\u1ea5n power query<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">L\u00fac n\u00e0y m\u1ed9t th\u00f4ng b\u00e1o c\u1ea3nh b\u00e1o s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb. Kh\u00f4ng ph\u1ea3i t\u1ea5t c\u1ea3 c\u00e1c th\u00f4ng b\u00e1o c\u1ea3nh b\u00e1o \u0111\u1ec1u x\u1ea5u; b\u1ea1n h\u00e3y xem k\u1ef9 n\u00f3 c\u00f3 li\u00ean quan \u0111\u1ebfn vi\u1ec7c b\u1ea1n \u0111ang l\u00e0m hay kh\u00f4ng. Trong v\u00ed d\u1ee5 n\u00e0y, ch\u00fang ta \u0111ang c\u1ed1 g\u1eafng x\u00e1c \u0111\u1ecbnh l\u1ed7i, v\u00ec v\u1eady h\u00e3y nh\u1ea5p v\u00e0o <\/span><b>Insert<\/b><span style=\"font-weight: 400\">.<\/span><\/p>\n<figure id=\"attachment_34676\" aria-describedby=\"caption-attachment-34676\" style=\"width: 521px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34676 size-full\" title=\"17- ch\u1ec9nh s\u1eeda truy v\u1ea5n power query\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h17-4.png\" alt=\"17- ch\u1ec9nh s\u1eeda truy v\u1ea5n power query\" width=\"521\" height=\"209\"><figcaption id=\"caption-attachment-34676\" class=\"wp-caption-text\">17- ch\u1ec9nh s\u1eeda truy v\u1ea5n power query<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">B\u01b0\u1edbc m\u1edbi \u0111\u00e3 \u0111\u01b0\u1ee3c th\u00eam v\u00e0o (xem \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh b\u00ean d\u01b0\u1edbi).<\/span><\/p>\n<figure id=\"attachment_34677\" aria-describedby=\"caption-attachment-34677\" style=\"width: 285px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34677 size-full\" title=\"18- ch\u1ec9nh s\u1eeda truy v\u1ea5n power query\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h18-3.png\" alt=\"18- ch\u1ec9nh s\u1eeda truy v\u1ea5n power query\" width=\"285\" height=\"213\"><figcaption id=\"caption-attachment-34677\" class=\"wp-caption-text\">18- ch\u1ec9nh s\u1eeda truy v\u1ea5n power query<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">B\u00e2y gi\u1edd h\u00e3y nh\u1ea5p v\u00e0o b\u01b0\u1edbc <\/span><b>Calculated End of Month<\/b> <span style=\"font-weight: 400\">. \u00d4i tr\u1eddi\u2026 th\u1eadt c\u00f3 l\u1ed7i. \u0110i\u1ec1u n\u00e0y l\u00e0 do b\u01b0\u1edbc \u0111\u00f3 \u0111ang c\u1ed1 g\u1eafng t\u00ecm m\u1ed9t c\u1ed9t c\u00f3 t\u00ean l\u00e0 Date, c\u1ed9t n\u00e0y kh\u00f4ng c\u00f2n \u1edf \u0111\u00f3 n\u1eefa.<\/span><\/p>\n<figure id=\"attachment_34678\" aria-describedby=\"caption-attachment-34678\" style=\"width: 1088px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34678 size-full\" title=\"19- ch\u1ec9nh s\u1eeda truy v\u1ea5n power query\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h19-4.png\" alt=\"19- ch\u1ec9nh s\u1eeda truy v\u1ea5n power query\" width=\"1088\" height=\"372\"><figcaption id=\"caption-attachment-34678\" class=\"wp-caption-text\">19- ch\u1ec9nh s\u1eeda truy v\u1ea5n power query<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">N\u1ebfu b\u1ea1n v\u1eabn m\u1edf <\/span><span style=\"font-weight: 400\">Formula Bar<\/span><span style=\"font-weight: 400\">, b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y tham chi\u1ebfu \u0111\u1ebfn c\u1ed9t Date kh\u00f4ng c\u00f2n n\u1eefa (xem \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh \u1edf tr\u00ean)<\/span><\/p>\n<p><span style=\"font-weight: 400\">B\u00e2y gi\u1edd b\u1ea1n c\u00f3 m\u1ed9t s\u1ed1 \u0111i\u1ec1u ph\u1ea3i c\u00e2n nh\u1eafc. B\u1ea1n c\u00f3 ch\u1eafc ch\u1eafn c\u1ea7n ph\u1ea3i ch\u00e8n b\u01b0\u1edbc \u0111\u00f3 v\u00e0o th\u1eddi \u0111i\u1ec3m n\u00e0y kh\u00f4ng? B\u1ea1n c\u00f3 n\u00ean x\u00f3a v\u00e0 th\u1ef1c hi\u1ec7n l\u1ea1i c\u00e1c b\u01b0\u1edbc b\u1ecb \u1ea3nh h\u01b0\u1edfng kh\u00f4ng? B\u1ea1n c\u00f3 n\u00ean t\u1ea1o m\u00e3 M c\u1ee7a c\u00e1c b\u01b0\u1edbc c\u00f2n l\u1ea1i \u0111\u1ec3 sao ch\u00e9p thay \u0111\u1ed5i kh\u00f4ng? Ch\u1ec9 b\u1ea1n m\u1edbi c\u00f3 th\u1ec3 \u0111\u01b0a ra quy\u1ebft \u0111\u1ecbnh n\u00e0y. Th\u1ef1c ra khi b\u1ea1n \u0111\u00e3 r\u01a1i v\u00e0o t\u00ecnh hu\u1ed1ng n\u00e0y m\u1ed9t v\u00e0i l\u1ea7n, b\u1ea1n s\u1ebd s\u1edbm t\u00ecm ra c\u00e1ch t\u1ed1t nh\u1ea5t th\u00f4i.<\/span><\/p>\n<p><span style=\"font-weight: 400\">N\u1ebfu b\u1ea1n ch\u1ecdn x\u00f3a t\u1ea5t c\u1ea3 c\u00e1c b\u01b0\u1edbc c\u00f2n l\u1ea1i, h\u00e3y nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o b\u01b0\u1edbc \u0111\u00f3 v\u00e0 ch\u1ecdn Delete Until End.<\/span><\/p>\n<figure id=\"attachment_34679\" aria-describedby=\"caption-attachment-34679\" style=\"width: 282px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34679 size-full\" title=\"20- ch\u1ec9nh s\u1eeda truy v\u1ea5n power query\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h20-4.png\" alt=\"20- ch\u1ec9nh s\u1eeda truy v\u1ea5n power query\" width=\"282\" height=\"403\"><figcaption id=\"caption-attachment-34679\" class=\"wp-caption-text\">20- ch\u1ec9nh s\u1eeda truy v\u1ea5n power query<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">V\u00ec \u0111\u00e2y ch\u1ec9 l\u00e0 minh h\u1ecda v\u1ec1 c\u00e1c v\u1ea5n \u0111\u1ec1 c\u00f3 th\u1ec3 x\u1ea3y ra v\u1edbi c\u00e1c b\u01b0\u1edbc thay \u0111\u1ed5i, h\u00e3y x\u00f3a b\u01b0\u1edbc <\/span><span style=\"font-weight: 400\">Renamed Columns<\/span><span style=\"font-weight: 400\"> (C\u1ed9t \u0111\u00e3 \u0111\u1ed5i t\u00ean) m\u00e0 ch\u00fang ta \u0111\u00e3 th\u00eam, Nh\u1ea5p v\u00e0o X b\u00ean c\u1ea1nh \u0111\u1ec3 x\u00f3a.<\/span><\/p>\n<figure id=\"attachment_34680\" aria-describedby=\"caption-attachment-34680\" style=\"width: 280px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34680 size-full\" title=\"21- ch\u1ec9nh s\u1eeda truy v\u1ea5n power query\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h21-5.png\" alt=\"21- ch\u1ec9nh s\u1eeda truy v\u1ea5n power query\" width=\"280\" height=\"270\"><figcaption id=\"caption-attachment-34680\" class=\"wp-caption-text\">21- ch\u1ec9nh s\u1eeda truy v\u1ea5n power query<\/figcaption><\/figure>\n<p><b>C\u00e1c b\u01b0\u1edbc di chuy\u1ec3n<\/b><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 di chuy\u1ec3n m\u1ed9t b\u01b0\u1edbc l\u00ean ho\u1eb7c xu\u1ed1ng c\u00f3 c\u00e1c t\u00f9y ch\u1ecdn. Ch\u00fang ta c\u00f3 th\u1ec3 nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o b\u01b0\u1edbc \u0111\u00f3 v\u00e0 nh\u1ea5p v\u00e0o <\/span><b>Move Up<\/b><span style=\"font-weight: 400\"> ho\u1eb7c <\/span><b>Move Down<\/b><span style=\"font-weight: 400\">.<\/span><span style=\"font-weight: 400\">.<\/span><\/p>\n<figure id=\"attachment_34681\" aria-describedby=\"caption-attachment-34681\" style=\"width: 283px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34681 size-full\" title=\"22- ch\u1ec9nh s\u1eeda truy v\u1ea5n power query\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h22-3.png\" alt=\"22- ch\u1ec9nh s\u1eeda truy v\u1ea5n power query\" width=\"283\" height=\"407\"><figcaption id=\"caption-attachment-34681\" class=\"wp-caption-text\">22- ch\u1ec9nh s\u1eeda truy v\u1ea5n power query<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">M\u1ed9t c\u00e1ch kh\u00e1c \u0111\u00f3 l\u00e0 nh\u1ea5p v\u00e0o m\u1ed9t b\u01b0\u1edbc duy nh\u1ea5t, gi\u1eef n\u00fat chu\u1ed9t v\u00e0 k\u00e9o b\u01b0\u1edbc \u0111\u00f3 \u0111\u1ebfn v\u1ecb tr\u00ed m\u1edbi.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Nh\u01b0 b\u1ea1n c\u00f3 th\u1ec3 t\u01b0\u1edfng t\u01b0\u1ee3ng, vi\u1ec7c di chuy\u1ec3n c\u00e1c b\u01b0\u1edbc c\u00f3 c\u00f9ng v\u1ea5n \u0111\u1ec1 v\u1edbi vi\u1ec7c ch\u00e8n c\u00e1c b\u01b0\u1edbc.<\/span><\/p>\n<p><b>B\u01b0\u1edbc b\u1ea1n v\u1eeba l\u00e0m \u0111\u00e3 \u0111i v\u1ec1 \u0111\u00e2u?<\/b><\/p>\n<p><span style=\"font-weight: 400\">Power Query r\u1ea5t th\u00f4ng minh, n\u00f3 c\u1ed1 g\u1eafng nh\u00f3m c\u00e1c h\u00e0nh \u0111\u1ed9ng t\u01b0\u01a1ng t\u1ef1 l\u1ea1i v\u1edbi nhau.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Ch\u1ecdn truy v\u1ea5n <\/span><b>SalesByDay<\/b><span style=\"font-weight: 400\"> v\u00e0 \u0111\u1ea3m b\u1ea3o b\u1ea1n \u0111\u00e3 ch\u1ecdn b\u01b0\u1edbc cu\u1ed1i c\u00f9ng, \u0111\u00f3 l\u00e0 <\/span><b>Removed Columns<\/b><span style=\"font-weight: 400\">. B\u00e2y gi\u1edd ch\u00fang ta s\u1ebd thay \u0111\u1ed5i ti\u00eau \u0111\u1ec1 c\u1ee7a m\u1ed7i c\u1ed9t:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><b>Day Name<\/b><span style=\"font-weight: 400\"> th\u00e0nh <\/span><b>Day<\/b><span style=\"font-weight: 400\"> \u2013 m\u1ed9t b\u01b0\u1edbc m\u1edbi \u0111\u00e3 \u0111\u01b0\u1ee3c th\u00eam v\u00e0o.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Ng\u00e0y <\/span><b>31\/01\/2019<\/b><span style=\"font-weight: 400\"> (ho\u1eb7c ng\u00e0y t\u01b0\u01a1ng \u0111\u01b0\u01a1ng t\u1ea1i \u0111\u1ecba ph\u01b0\u01a1ng c\u1ee7a b\u1ea1n) thay \u0111\u1ed5i th\u00e0nh <\/span><b>Number of Sales<\/b><span style=\"font-weight: 400\"> \u2013 m\u1ed9t b\u01b0\u1edbc m\u1edbi kh\u00f4ng \u0111\u01b0\u1ee3c th\u00eam v\u00e0o.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">Nh\u00ecn l\u1ea1i c\u00e1c b\u01b0\u1edbc \u0111\u00e3 \u00e1p d\u1ee5ng\u2026ch\u1ec9 c\u00f3 m\u1ed9t b\u01b0\u1edbc \u0111\u01b0\u1ee3c th\u00eam v\u00e0o, v\u1eady b\u01b0\u1edbc th\u1ee9 hai \u0111\u00e3 \u0111i \u0111\u1ebfn \u0111\u00e2u?<\/span><\/p>\n<figure id=\"attachment_34682\" aria-describedby=\"caption-attachment-34682\" style=\"width: 1237px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34682 size-full\" title=\"23- ch\u1ec9nh s\u1eeda truy v\u1ea5n power query\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h23-3.png\" alt=\"23- ch\u1ec9nh s\u1eeda truy v\u1ea5n power query\" width=\"1237\" height=\"296\"><figcaption id=\"caption-attachment-34682\" class=\"wp-caption-text\">23- ch\u1ec9nh s\u1eeda truy v\u1ea5n power query<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Nh\u00ecn v\u00e0o <\/span><span style=\"font-weight: 400\">Formula Bar<\/span><span style=\"font-weight: 400\"> (n\u1ebfu b\u1ea1n m\u1edf n\u00f3), b\u1ea1n s\u1ebd th\u1ea5y r\u1eb1ng c\u1ea3 hai b\u01b0\u1edbc \u0111\u00e3 \u0111\u01b0\u1ee3c k\u1ebft h\u1ee3p th\u00e0nh m\u1ed9t.<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u0110i\u1ec1u n\u00e0y ch\u1ec9 x\u1ea3y ra khi c\u00e1c b\u01b0\u1edbc t\u01b0\u01a1ng t\u1ef1 \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n l\u1ea7n l\u01b0\u1ee3t. N\u00f3 ch\u1eafc ch\u1eafn s\u1ebd gi\u00fap gi\u1eef cho c\u00e1c b\u01b0\u1edbc \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng nh\u1ecf h\u01a1n \u0111\u00e1ng k\u1ec3 so v\u1edbi nh\u1eefng b\u01b0\u1edbc kh\u00e1c.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ma_M_trong_thanh_cong_thuc_Trinh_chinh_sua_nang_cao\"><\/span><span style=\"font-weight: 400\">M\u00e3 M trong thanh c\u00f4ng th\u1ee9c &amp; Tr\u00ecnh ch\u1ec9nh s\u1eeda n\u00e2ng cao<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">C\u00f3 v\u1ebb nh\u01b0 m\u1ecdi th\u1ee9 \u0111ang tr\u1edf n\u00ean nghi\u00eam tr\u1ecdng, c\u00e1ch gi\u1ea3i quy\u1ebft l\u00e0 ch\u00fang ta s\u1ebd thay \u0111\u1ed5i m\u00e3 M! Ch\u00fang ta c\u00f3 th\u1ec3 ch\u1ec9nh s\u1eeda m\u00e3 M tr\u1ef1c ti\u1ebfp theo hai c\u00e1ch (1) Thanh c\u00f4ng th\u1ee9c (2) Tr\u00ecnh ch\u1ec9nh s\u1eeda n\u00e2ng cao. C\u00e1 nh\u00e2n m\u00ecnh th\u00edch d\u00f9ng thanh c\u00f4ng th\u1ee9c h\u01a1n n\u00ean ch\u00fang ta s\u1ebd b\u1eaft \u0111\u1ea7u v\u1edbi v\u1edbi n\u00f3 nh\u00e9!<\/span><\/p>\n<p><b>Thanh c\u00f4ng th\u1ee9c<\/b><\/p>\n<p><span style=\"font-weight: 400\">N\u1ebfu thanh c\u00f4ng th\u1ee9c kh\u00f4ng hi\u1ec3n th\u1ecb, ch\u00fang ta c\u00f3 th\u1ec3 b\u1eadt n\u00f3 b\u1eb1ng c\u00e1ch nh\u1ea5p v\u00e0o <\/span><b>View -&gt; Formula Bar<\/b><\/p>\n<p><span style=\"font-weight: 400\">Ch\u1ecdn truy v\u1ea5n <\/span><b>SalesByDay<\/b><span style=\"font-weight: 400\"> v\u00e0 nh\u1ea5p v\u00e0o b\u01b0\u1edbc <\/span><b>Sorted Rows<\/b><span style=\"font-weight: 400\">.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Thanh c\u00f4ng th\u1ee9c s\u1ebd hi\u1ec3n th\u1ecb nh\u01b0 sau:<\/span><\/p>\n<figure id=\"attachment_34683\" aria-describedby=\"caption-attachment-34683\" style=\"width: 764px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34683 size-full\" title=\"24- ch\u1ec9nh s\u1eeda truy v\u1ea5n power query\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h24-3.png\" alt=\"24- ch\u1ec9nh s\u1eeda truy v\u1ea5n power query\" width=\"764\" height=\"41\"><figcaption id=\"caption-attachment-34683\" class=\"wp-caption-text\">24- ch\u1ec9nh s\u1eeda truy v\u1ea5n power query<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Ch\u00fang ta c\u00f3 th\u1ec3 kh\u00f4ng vi\u1ebft \u0111\u01b0\u1ee3c m\u00e3 M t\u1eeb \u0111\u1ea7u, nh\u01b0ng \u0111i\u1ec1u \u0111\u00f3 kh\u00f4ng c\u00f3 ngh\u0129a l\u00e0 ch\u00fang ta kh\u00f4ng th\u1ec3 ch\u1ec9nh s\u1eeda n\u00f3. Trong thanh c\u00f4ng th\u1ee9c, thay \u0111\u1ed5i \u201c<\/span><b>Day of Week<\/b><span style=\"font-weight: 400\">\u201d th\u00e0nh \u201c<\/span><b>Day Name<\/b><span style=\"font-weight: 400\">\u201d<\/span><span style=\"font-weight: 400\">. Nh\u00ecn v\u00e0o c\u1eeda s\u1ed5 xem tr\u01b0\u1edbc d\u1eef li\u1ec7u b\u1ea1n s\u1ebd th\u1ea5y b\u00e2y gi\u1edd n\u00f3 \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 b\u1ea3ng ch\u1eef c\u00e1i d\u1ef1a tr\u00ean <\/span><b>Day Name.<\/b><\/p>\n<p><span style=\"font-weight: 400\">Sau \u0111\u00f3, thay \u0111\u1ed5i v\u0103n b\u1ea3n c\u00f3 n\u1ed9i dung <\/span><b>Order.Ascending<\/b><span style=\"font-weight: 400\"> th\u00e0nh <\/span><b>Order.Descending<\/b><span style=\"font-weight: 400\">. Ki\u1ec3m tra l\u1ea1i c\u1eeda s\u1ed5 xem tr\u01b0\u1edbc v\u00e0 nh\u1eadn th\u1ea5y th\u1ee9 t\u1ef1 \u0111\u00e3 thay \u0111\u1ed5i.<\/span><\/p>\n<p><span style=\"font-weight: 400\">C\u00f4ng th\u1ee9c cu\u1ed1i c\u00f9ng s\u1ebd gi\u1ed1ng nh\u01b0 sau:<\/span><\/p>\n<figure id=\"attachment_34684\" aria-describedby=\"caption-attachment-34684\" style=\"width: 728px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34684 size-full\" title=\"25- ch\u1ec9nh s\u1eeda truy v\u1ea5n power query\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h25-3.png\" alt=\"25- ch\u1ec9nh s\u1eeda truy v\u1ea5n power query\" width=\"728\" height=\"39\"><figcaption id=\"caption-attachment-34684\" class=\"wp-caption-text\">25- ch\u1ec9nh s\u1eeda truy v\u1ea5n power query<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Nh\u1ea5p v\u00e0o b\u01b0\u1edbc cu\u1ed1i c\u00f9ng trong truy v\u1ea5n. B\u1ea3n xem tr\u01b0\u1edbc d\u1eef li\u1ec7u b\u00e2y gi\u1edd tr\u00f4ng nh\u01b0 th\u1ebf n\u00e0y.<\/span><\/p>\n<figure id=\"attachment_34685\" aria-describedby=\"caption-attachment-34685\" style=\"width: 921px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34685 size-full\" title=\"26- ch\u1ec9nh s\u1eeda truy v\u1ea5n power query\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h26-2.png\" alt=\"26- ch\u1ec9nh s\u1eeda truy v\u1ea5n power query\" width=\"921\" height=\"237\"><figcaption id=\"caption-attachment-34685\" class=\"wp-caption-text\">26- ch\u1ec9nh s\u1eeda truy v\u1ea5n power query<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Nh\u1eefng thay \u0111\u1ed5i ch\u00fang ta th\u1ef1c hi\u1ec7n trong thanh c\u00f4ng th\u1ee9c \u1edf tr\u00ean \u0111\u00e3 \u0111\u01b0\u1ee3c ph\u1ea3n \u00e1nh trong truy v\u1ea5n c\u1ee7a ch\u00fang ta.<\/span><\/p>\n<p><b>Tr\u00ecnh ch\u1ec9nh s\u1eeda n\u00e2ng cao<\/b><\/p>\n<p><span style=\"font-weight: 400\">Ch\u00fang ta c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n nh\u1eefng thay \u0111\u1ed5i t\u01b0\u01a1ng t\u1ef1 trong Tr\u00ecnh ch\u1ec9nh s\u1eeda n\u00e2ng cao. Nh\u1ea5p v\u00e0o <\/span><b>Home -&gt; Advanced Editor<\/b><span style=\"font-weight: 400\">.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Advanced Editor s\u1ebd hi\u1ec3n th\u1ecb t\u1eebng b\u01b0\u1edbc, ch\u00fang ta ph\u1ea3i x\u00e1c \u0111\u1ecbnh d\u00f2ng c\u00f3 li\u00ean quan, sau \u0111\u00f3 h\u00e3y th\u1ef1c hi\u1ec7n c\u00e1c thay \u0111\u1ed5i t\u01b0\u01a1ng t\u1ef1.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tai_vao_Excel\"><\/span><b>T\u1ea3i v\u00e0o Excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Cu\u1ed1i c\u00f9ng, h\u00e3y nh\u1ea5p v\u00e0o <\/span><b>Close and Load<\/b><span style=\"font-weight: 400\">. Nh\u1eefng thay \u0111\u1ed5i ch\u00fang ta \u0111\u00e3 th\u1ef1c hi\u1ec7n s\u1ebd \u0111\u01b0\u1ee3c t\u1ea3i l\u00ean c\u00e1c B\u1ea3ng tr\u00ean trang t\u00ednh.<br \/>\n<\/span><\/p>\n<p><em>Vi\u1ec7c <strong>ch\u1ec9nh s\u1eeda truy v\u1ea5n trong Power Query<\/strong> c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n b\u1eb1ng nhi\u1ec1u c\u00e1ch nh\u01b0 v\u1eady \u0111\u00f3. M\u1ed7i c\u00e1ch \u0111\u1ec1u c\u00f3 \u01b0u v\u00e0 nh\u01b0\u1ee3c \u0111i\u1ec3m. <strong>H\u1ecdc Excel Online<\/strong> s\u1ebd ti\u1ebfp t\u1ee5c h\u01b0\u1edbng d\u1eabn c\u1ee5 th\u1ec3 c\u00e1c b\u1ea1n v\u1ec1 Power Query trong lo\u1ea1t b\u00e0i vi\u1ebft s\u1eafp t\u1edbi!<\/em><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-227.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2986,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-2985","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2985","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=2985"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2985\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2986"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2985"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2985"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2985"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}