{"id":6228,"date":"2024-12-21T14:12:43","date_gmt":"2024-12-21T14:12:43","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/su-dung-ham-dax-trong-power-pivot\/"},"modified":"2024-12-21T14:12:43","modified_gmt":"2024-12-21T14:12:43","slug":"su-dung-ham-dax-trong-power-pivot","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/su-dung-ham-dax-trong-power-pivot\/","title":{"rendered":"S\u1eed d\u1ee5ng h\u00e0m DAX trong Power Pivot"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-Bh-YYrla#1\">\n<p><em>N\u1ebfu b\u1ea1n l\u00e0 m\u1ed9t ng\u01b0\u1eddi d\u00f9ng <strong>Power BI,<\/strong> ch\u1eafc h\u1eb3n b\u1ea1n \u0111\u00e3 qu\u00e1 quen thu\u00f4c v\u1edbi <a href=\"http:\/\/blog.ezworkapp.com\/power-bi\/dax\">DAX \u2013 Data Analysis Expression<\/a>. Tuy v\u1eady b\u1ea1n c\u00f3 bi\u1ebft r\u1eb1ng, ta c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/su-dung-ham-dax-trong-power-pivot.html\"><strong>DAX trong Power Pivot<\/strong><\/a>?<\/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-6766ccda31c98\" 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-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/su-dung-ham-dax-trong-power-pivot.html#Su_dung_ham_DAX_trong_Power_Pivot\" title=\"S\u1eed d\u1ee5ng h\u00e0m DAX trong Power Pivot\">S\u1eed d\u1ee5ng h\u00e0m DAX trong Power Pivot<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/su-dung-ham-dax-trong-power-pivot.html#Cac_buoc_su_dung\" title=\"C\u00e1c b\u01b0\u1edbc s\u1eed d\u1ee5ng\">C\u00e1c b\u01b0\u1edbc s\u1eed d\u1ee5ng<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_ham_DAX_trong_Power_Pivot\"><\/span>S\u1eed d\u1ee5ng h\u00e0m DAX trong Power Pivot<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>T\u1ea5t c\u1ea3 c\u00e1c h\u00e0m DAX \u0111\u1ec1u b\u1eaft \u0111\u1ea7u v\u1edbi d\u1ea5u b\u1eb1ng (=) gi\u1ed1ng v\u1edbi c\u00e1c c\u00f4ng th\u1ee9c Excel th\u00f4ng th\u01b0\u1eddng. \u0110\u1ed3ng th\u1eddi khi b\u1ea1n g\u00f5 ch\u1eef c\u00e1i \u0111\u1ea7u ti\u00ean, b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c g\u1ee3i \u00fd v\u1ec1 c\u00e1c h\u00e0m b\u1eaft \u0111\u1ea7u b\u1eb1ng ch\u1eef c\u00e1i \u0111\u00f3, c\u0169ng nh\u01b0 khi b\u1ea1n \u0111\u00e3 ch\u1ecdn \u0111\u01b0\u1ee3c h\u00e0m, b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c g\u1ee3i \u00fd c\u00e1c th\u00e0nh ph\u1ea7n \u0111\u1ec3 ho\u00e0n th\u00e0nh c\u00f4ng th\u1ee9c. V\u1ec1 c\u01a1 b\u1ea3n c\u00f3 th\u1ec3 n\u00f3i r\u1eb1ng, s\u1eed d\u1ee5ng DAX trong Power Pivot v\u00e0 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c trong Excel c\u00f3 kha kh\u00e1 \u0111i\u1ec3m t\u01b0\u01a1ng \u0111\u1ed3ng.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-32202 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dax-trong-power-pivot-3.png\" alt=\"dax-trong-power-pivot-1\" width=\"640\" height=\"455\" title=\"dax-trong-power-pivot-3\"><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-32200 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dax-trong-power-pivot-1.png\" alt=\"dax-trong-power-pivot-2\" width=\"562\" height=\"433\" title=\"dax-trong-power-pivot-1\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cac_buoc_su_dung\"><\/span>C\u00e1c b\u01b0\u1edbc s\u1eed d\u1ee5ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>B\u01b0\u1edbc 1: M\u1edf c\u1eeda s\u1ed5 <strong>Power Pivot <\/strong>v\u00e0 ch\u1ecdn b\u1ea3ng c\u1ea7n th\u00eam.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-32201 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dax-trong-power-pivot-2-1024x544-1.png\" alt=\"dax-trong-power-pivot-3\" width=\"1024\" height=\"544\" title=\"dax-trong-power-pivot-2-1024x544-1\"><\/p>\n<p>\u00a0<\/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-559.gif\" title=\"ex101_92019-nho-559\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>B\u01b0\u1edbc 2: Trong th\u1ebb\u00a0<strong>Design,\u00a0<\/strong>ch\u1ecdn <strong>Add<\/strong>. PowerPivot s\u1ebd th\u00eam m\u1ed9t c\u1ed9t m\u1edbi \u1edf v\u1ecb tr\u00ed cu\u1ed1i c\u00f9ng c\u1ee7a b\u1ea3ng d\u1eef li\u1ec7u.<\/p>\n<p>B\u01b0\u1edbc 3: B\u1eaft \u0111\u1ea7u g\u00f5 k\u00ed t\u1ef1 \u201c<strong>=<\/strong>\u201d \u0111\u1ec3 x\u00e2y d\u1ef1ng bi\u1ec3u th\u1ee9c DAX<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-32203 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dax-trong-power-pivot-4-1024x429-1.png\" alt=\"dax-trong-power-pivot-4\" width=\"1024\" height=\"429\" title=\"dax-trong-power-pivot-4-1024x429-1\"><\/p>\n<p>Sau khi b\u1ea1n \u1ea5n Enter \u0111\u1ec3 ho\u00e0n th\u00e0nh c\u00f4ng th\u1ee9c, PowerPivot s\u1ebd tr\u1ea3 k\u1ebft qu\u1ea3 trong c\u1ed9t m\u1edbi v\u1eeba t\u1ea1o. Qu\u00e1 tr\u00ecnh n\u00e0y t\u1ed1n \u00edt hay nhi\u1ec1u th\u1eddi gian ph\u1ee5 thu\u1ed9c v\u00e0o s\u1ed1 l\u01b0\u1ee3ng record trong data. \u0110\u1ec3 ch\u1ec9nh s\u1eeda, b\u1ea1n ch\u1ec9 c\u1ea7n click v\u00e0o ti\u00eau \u0111\u1ec1, ch\u1ecdn to\u00e0n b\u1ed9 c\u1ed9t v\u00e0 g\u00f5 l\u1ea1i bi\u1ec3u th\u1ee9c tr\u00ean thanh Formula c\u1ee7a PowerPivot.<\/p>\n<p>Trong tr\u01b0\u1eddng h\u1ee3p c\u1ea7n x\u00f3a c\u1ed9t, b\u1ea1n ch\u1ec9 c\u1ea7n click chu\u1ed9t ph\u1ea3i v\u00e0o c\u1ed9t c\u1ea7n x\u00f3a, sau \u0111\u00f3 ch\u1ecdn Delete Column.<\/p>\n<p><em>C\u00e1ch s\u1eed d\u1ee5ng <strong>h\u00e0m Dax trong Power Pivot<\/strong> \u0111\u00e3 \u0111\u01b0\u1ee3c t\u00f3m t\u1eaft trong b\u00e0i vi\u1ebft c\u1ee7a <strong>H\u1ecdc Excel Online<\/strong> r\u1ed3i. B\u1ea1n c\u00f2n b\u1ea5t c\u1ee9 th\u1eafc m\u1eafc n\u00e0o \u0111\u1eebng ng\u1ea1i ng\u1ea7n m\u00e0 b\u00ecnh lu\u1eadn xu\u1ed1ng d\u01b0\u1edbi, ch\u00fang t\u00f4i s\u1ebd gi\u1ea3i \u0111\u00e1p trong t\u00edch t\u1eafc.<\/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-559.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":6229,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-6228","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\/6228","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=6228"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6228\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6229"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6228"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6228"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6228"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}