{"id":3275,"date":"2024-12-03T01:37:47","date_gmt":"2024-12-03T01:37:47","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/power-query-da-cuu-vot-thoi-gian-thuc-tap-cua-minh-nhu-nao-phan-4\/"},"modified":"2024-12-03T01:37:47","modified_gmt":"2024-12-03T01:37:47","slug":"power-query-da-cuu-vot-thoi-gian-thuc-tap-cua-minh-nhu-nao-phan-4","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/power-query-da-cuu-vot-thoi-gian-thuc-tap-cua-minh-nhu-nao-phan-4\/","title":{"rendered":"Power Query \u0111\u00e3 c\u1ee9u v\u1edbt th\u1eddi gian th\u1ef1c t\u1eadp c\u1ee7a m\u00ecnh nh\u01b0 n\u00e0o? \u2013 Ph\u1ea7n 4"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-h4k0Fa0I#1\">\n<p><em>T\u1ea1i ph\u1ea7n 4 n\u00e0y, m\u00ecnh s\u1ebd n\u00f3i \u0111\u1ebfn m\u1ed9t s\u1ed1 v\u1ea5n \u0111\u1ec1 x\u1ea3y ra khi s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/power-query-da-cuu-vot-thuc-tap-nhu-nao-4.html\"><strong>Power Query<\/strong><\/a> v\u00e0 <strong>Power Pivot<\/strong> \u0111\u1ec3 l\u00e0m b\u00e1o c\u00e1o, c\u00f9ng v\u1edbi vi\u1ec7c m\u00ecnh \u0111\u00e3 \u1ee9ng d\u1ee5ng <strong>h\u00e0m DAX c\u01a1 b\u1ea3n trong Pivot Table ra sao<\/strong>.<\/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-674e60eaa3125\" 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-da-cuu-vot-thuc-tap-nhu-nao-4.html#Tao_bieu_do_voi_Power_Pivot\" title=\"T\u1ea1o bi\u1ec3u \u0111\u1ed3 v\u1edbi Power Pivot\">T\u1ea1o bi\u1ec3u \u0111\u1ed3 v\u1edbi Power Pivot<\/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-da-cuu-vot-thuc-tap-nhu-nao-4.html#Vay_cac_van_de_minh_da_gap_phai_voi_Power_Pivot_la_gi\" title=\"V\u1eady c\u00e1c v\u1ea5n \u0111\u1ec1 m\u00ecnh \u0111\u00e3 g\u1eb7p ph\u1ea3i v\u1edbi Power Pivot l\u00e0 g\u00ec?\">V\u1eady c\u00e1c v\u1ea5n \u0111\u1ec1 m\u00ecnh \u0111\u00e3 g\u1eb7p ph\u1ea3i v\u1edbi Power Pivot l\u00e0 g\u00ec?<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\">\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/power-query-da-cuu-vot-thuc-tap-nhu-nao-4.html#Khong_Group_duoc\" title=\"Kh\u00f4ng Group \u0111\u01b0\u1ee3c\">Kh\u00f4ng Group \u0111\u01b0\u1ee3c<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/power-query-da-cuu-vot-thuc-tap-nhu-nao-4.html#Mot_so_du_lieu_can_gop\" title=\"M\u1ed9t s\u1ed1 d\u01b0 li\u1ec7u c\u1ea7n g\u1ed9p\">M\u1ed9t s\u1ed1 d\u01b0 li\u1ec7u c\u1ea7n g\u1ed9p<\/a><\/li>\n<\/ul>\n<\/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-da-cuu-vot-thuc-tap-nhu-nao-4.html#Ham_DAX_co_ban_trong_Power_Query\" title=\"H\u00e0m DAX c\u01a1 b\u1ea3n trong Power Query\">H\u00e0m DAX c\u01a1 b\u1ea3n trong Power Query<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Tao_bieu_do_voi_Power_Pivot\"><\/span>T\u1ea1o bi\u1ec3u \u0111\u1ed3 v\u1edbi Power Pivot<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Sau c\u00e1c b\u01b0\u1edbc th\u00eam d\u1eef li\u1ec7u v\u00e0o, m\u00ecnh \u0111\u00e3 c\u00f3 s\u01a1 s\u01a1 \u201c1 v\u00e0i\u201d query gi\u00fap m\u00ecnh t\u1ea1o ra c\u00e1c bi\u1ec3u \u0111\u1ed3 ph\u1ee5c v\u1ee5 dashboard. T\u1ea5t c\u1ea3 \u0111\u1ec1u \u1edf d\u01b0\u1edbi d\u1ea1ng Connection Only v\u00e0 \u0111\u00e3 \u0111\u01b0\u1ee3c \u0111\u01b0a v\u00e0o Data Model.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-32172 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/power-query-4-1.png\" alt=\"power-query-1\" width=\"381\" height=\"504\" title=\"power-query-4-1\"><\/p>\n<p>\u0110\u1ec3 t\u1ea1o ra Pivot Chart, ta ch\u1ecdn\u00a0<strong>Power Pivot<\/strong> sau \u0111\u00f3 \u1ea5n v\u00e0o nh\u01b0 \u1ea3nh:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-32173 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/power-query-4-2-1024x525-1.png\" alt=\"power-query-2\" width=\"1024\" height=\"525\" title=\"power-query-4-2-1024x525-1\"><\/p>\n<p>M\u00ecnh ti\u1ebfn h\u00e0nh c\u00e1c b\u01b0\u1edbc nh\u01b0 thao t\u00e1c v\u1edbi 1 Pivot Table\/Pivot Chart th\u00f4ng th\u01b0\u1eddng.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-32174 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/power-query-4-3-1024x518-1.png\" alt=\"power-query-3\" width=\"1024\" height=\"518\" title=\"power-query-4-3-1024x518-1\"><\/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-252.gif\" title=\"ex101_92019-nho-252\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Th\u1ef1c ra th\u00ec c\u0169ng\u2026 kh\u00f4ng c\u00f3 g\u00ec to t\u00e1t l\u1eafm. M\u00ecnh l\u00e0m tu\u1ea7n t\u1ef1 theo c\u00e1c b\u01b0\u1edbc. V\u00e0 th\u00e0nh qu\u1ea3 nh\u01b0 n\u00e0y:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-32175 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/power-query-4-4-1024x397-1.png\" alt=\"power-query-4\" width=\"1024\" height=\"397\" title=\"power-query-4-4-1024x397-1\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Vay_cac_van_de_minh_da_gap_phai_voi_Power_Pivot_la_gi\"><\/span>V\u1eady c\u00e1c v\u1ea5n \u0111\u1ec1 m\u00ecnh \u0111\u00e3 g\u1eb7p ph\u1ea3i v\u1edbi Power Pivot l\u00e0 g\u00ec?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h4><span class=\"ez-toc-section\" id=\"Khong_Group_duoc\"><\/span>Kh\u00f4ng Group \u0111\u01b0\u1ee3c<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>M\u00ecnh \u0111\u00e3 kh\u00e1 b\u0103n kho\u0103n v\u00e0 t\u00ecm hi\u1ec3u tr\u00ean Google. Nh\u01b0ng c\u00e1c c\u00e2u tr\u1ea3 l\u1eddi \u0111\u1ec1u l\u00e0: Kh\u00f4ng th\u1ec3 Group \u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb qua Data Model.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-32176 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/power-query-4-5.png\" alt=\"power-query-5\" width=\"443\" height=\"258\" title=\"power-query-4-5\"><\/p>\n<p>B\u1edfi v\u1eady, trong tr\u01b0\u1eddng h\u1ee3p mu\u1ed1n x\u1eed l\u00fd d\u1eef li\u1ec7u theo nh\u00f3m (tu\u1ea7n\/th\u00e1ng\/qu\u00fd\/n\u0103m), m\u00ecnh \u0111\u00e3 s\u1eed d\u1ee5ng th\u00eam c\u1ed9t ph\u1ee5.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Mot_so_du_lieu_can_gop\"><\/span>M\u1ed9t s\u1ed1 d\u01b0 li\u1ec7u c\u1ea7n g\u1ed9p<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u0110\u00e2y l\u00e0 v\u1ea5n \u0111\u1ec1 x\u1ea3y ra khi m\u00ecnh c\u1ea7n l\u00e0m b\u00e1o c\u00e1o tu\u1ea7n<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-32177 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/power-query-4-6.png\" alt=\"power-query-6\" width=\"227\" height=\"205\" title=\"power-query-4-6\"><\/p>\n<p>\u1ede \u0111\u00e2y, m\u00ecnh c\u1ea7n t\u00ednh t\u1ed5ng th\u1ea3o lu\u1eadn = Post + Comment v\u00e0 t\u1ed5ng Buzz = Th\u1ea3o lu\u1eadn + Like + Share. T\u1ea5t nhi\u00ean m\u00ecnh c\u00f3 th\u1ec3 t\u00ednh ngo\u00e0i, nh\u01b0ng v\u00ec \u0111\u00e3 t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng DAX, t\u1ed9i g\u00ec kh\u00f4ng d\u00f9ng c\u01a1 ch\u1ee9?<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ham_DAX_co_ban_trong_Power_Query\"><\/span><strong>H\u00e0m DAX c\u01a1 b\u1ea3n trong Power Query<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>V\u1edbi v\u1ea5n \u0111\u1ec1 tr\u00ean, m\u00ecnh \u0111\u00e3 s\u1eed d\u1ee5ng h\u00e0m DAX nh\u01b0 sau:<\/p>\n<ol>\n<li>Ch\u1ecdn b\u1ea3ng ngu\u1ed3n l\u00e0m Pivot, click chu\u1ed9t ph\u1ea3i v\u00e0\u00a0<strong>Add measure:<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-32178 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/power-query-4-7.png\" alt=\"power-query-7\" width=\"348\" height=\"533\" title=\"power-query-4-7\"><\/strong><\/li>\n<li>Nh\u1eadp c\u00e1c gi\u00e1 tr\u1ecb v\u00e0o \u00f4 bao g\u1ed3m: t\u00ean measure v\u00e0 ch\u00fa th\u00edch:<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-32179 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/power-query-4-8.png\" alt=\"power-query-8\" width=\"565\" height=\"432\" title=\"power-query-4-8\"><\/li>\n<li>T\u1ea1i m\u1ee5c Formula, nh\u1eadp c\u00f4ng th\u1ee9c DAX. C\u1ee5 th\u1ec3 v\u1ec1 h\u00e0m DAX<\/li>\n<\/ol>\n<figure id=\"attachment_32180\" aria-describedby=\"caption-attachment-32180\" style=\"width: 564px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-32180 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/power-query-4-9.png\" alt=\"M\u1ed9t c\u00f4ng th\u1ee9c ti\u00eau bi\u1ec3u c\u01a1 b\u1ea3n c\u1ee7a m\u00ecnh\" width=\"564\" height=\"436\" title=\"power-query-4-9\"><figcaption id=\"caption-attachment-32180\" class=\"wp-caption-text\">M\u1ed9t c\u00f4ng th\u1ee9c ti\u00eau bi\u1ec3u c\u01a1 b\u1ea3n c\u1ee7a m\u00ecnh<\/figcaption><\/figure>\n<p>V\u1edbi Power Query, <a href=\"http:\/\/blog.ezworkapp.com\/su-dung-ham-dax-trong-power-pivot.html\"><strong>Power Pivot<\/strong> <\/a>k\u1ebft h\u1ee3p v\u1edbi DAX, m\u00ecnh \u0111\u00e3 gi\u1ea3i quy\u1ebft \u0111\u01b0\u1ee3c ph\u1ea7n c\u00f4ng vi\u1ec7c th\u1ef1c t\u1eadp m\u1ed9t c\u00e1ch kh\u00e1 nhanh ch\u00f3ng. C\u00f4ng vi\u1ec7c h\u00e0ng ng\u00e0y c\u1ee7a m\u00ecnh chuy\u1ec3n th\u00e0nh\u00a0<strong>t\u1ea3i d\u1eef li\u1ec7u v\u00e0o folder ch\u1ec9 \u0111\u1ecbnh -&gt; l\u00e0m s\u1ea1ch d\u1eef li\u1ec7u -&gt; \u0111\u00f3ng file -&gt; m\u1edf file dashboard -&gt; ch\u1ecdn refresh<\/strong>. V\u00e0 m\u00ecnh \u0111\u00e3 c\u00f3 m\u1ed9t dashboard ho\u00e0n to\u00e0n m\u1edbi c\u1eadp nh\u1eadt h\u00e0ng ng\u00e0y. C\u00f4ng vi\u1ec7c cu\u1ed1i c\u00f9ng ch\u1ec9 c\u00f2n copy paste c\u00e1c bi\u1ec3u \u0111\u1ed3 v\u00e0o PowerPoint v\u00e0 s\u1eeda so\u1ea1n cho m\u00ecnh m\u1ed9t b\u00e0i thuy\u1ebft tr\u00ecnh \u0111\u1eb9p m\u00e0 th\u00f4i.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-32181 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/power-query-4-10.png\" alt=\"M\u1ed9t c\u00f4ng th\u1ee9c ti\u00eau bi\u1ec3u c\u01a1 b\u1ea3n\" width=\"537\" height=\"218\" title=\"power-query-4-10\"><\/p>\n<hr>\n<p>Danh s\u00e1ch c\u00e1c ph\u1ea7n v\u1ec1 Power Query do <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> \u0111\u00e3 th\u1ef1c hi\u1ec7n \u1edf ph\u00eda d\u01b0\u1edbi. Ch\u00fac c\u00e1c b\u1ea1n mau ch\u00f3ng n\u1eafm r\u00f5 c\u00f4ng c\u1ee5 tuy\u1ec7t v\u1eddi n\u00e0y.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/power-query-da-cuu-vot-thuc-tap-nhu-nao-1.html\">Power Query Ph\u1ea7n 1<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/power-query-da-cuu-vot-thuc-tap-nhu-nao-2.html\">Power Query Ph\u1ea7n 2<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/power-query-da-cuu-vot-thuc-tap-nhu-nao-4.html\">Power Query Ph\u1ea7n 4<\/a><\/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-252.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3276,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-3275","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3275","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=3275"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3275\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3276"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3275"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3275"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3275"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}