{"id":4315,"date":"2023-07-18T12:38:15","date_gmt":"2023-07-18T03:38:15","guid":{"rendered":"https:\/\/memotarou.bulog.jp\/?p=4315"},"modified":"2023-07-01T16:24:06","modified_gmt":"2023-07-01T07:24:06","slug":"data-analysis-powerbi-q038","status":"publish","type":"post","link":"https:\/\/memotarou.bulog.jp\/?p=4315","title":{"rendered":"\u3010PowerBI\u3011Q-038"},"content":{"rendered":"<h2>\u554f\u984c<\/h2>\n<div align=\"center\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/07\/data-analysis-powerbi-q038.jpg\" alt=\"\" width=\"600\" height=\"600\" class=\"alignnone size-full wp-image-4317\" srcset=\"https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/07\/data-analysis-powerbi-q038.jpg 600w, https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/07\/data-analysis-powerbi-q038-300x300.jpg 300w, https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/07\/data-analysis-powerbi-q038-150x150.jpg 150w, https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/07\/data-analysis-powerbi-q038-75x75.jpg 75w, https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/07\/data-analysis-powerbi-q038-100x100.jpg 100w, https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/07\/data-analysis-powerbi-q038-530x530.jpg 530w, https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/07\/data-analysis-powerbi-q038-565x565.jpg 565w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/div>\n<h3>\u554f\u984c.038<\/h3>\n<p>PowerBIDesktop\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u306b\u306f\u3001\u6b21\u306e\u5217\u3092\u6301\u3064\u5404\u5f93\u696d\u54e1\u306e\u884c\u3092\u542b\u3080Employees\u3068\u3044\u3046\u540d\u524d\u306e\u30c6\u30fc\u30d6\u30eb\u304c\u542b\u307e\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n<p>\u30fb\u5f93\u696d\u54e1ID<br \/>\n\u30fb\u5f93\u696d\u54e1\u540d<br \/>\n\u30fb\u30de\u30cd\u30fc\u30b8\u30e3\u30fcID<br \/>\n\u30fb\u30de\u30cd\u30fc\u30b8\u30e3\u30fc\u540d<\/p>\n<p>\u5404\u5f93\u696d\u54e1\u306e\u3059\u3079\u3066\u306e\u76f4\u63a5\u304a\u3088\u3073\u9593\u63a5\u30de\u30cd\u30fc\u30b8\u30e3\u30fc\u306e\u5f93\u696d\u54e1ID\u306e\u30ea\u30b9\u30c8\u3092\u542b\u3080\u5217\u3092\u8ffd\u52a0\u3057\u3066\u3001Employees\u30c6\u30fc\u30d6\u30eb\u306e\u89aa\u5b50\u968e\u5c64\u3092\u5e73\u5766\u5316\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<p>\u3069\u306e2\u3064\u306eDataAnalysisExpression(DAX)\u95a2\u6570\u3092\u4f7f\u7528\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u304b\uff1f<\/p>\n<p>\uff08\u305d\u308c\u305e\u308c\u306e\u6b63\u89e3\u306f\u3001\u89e3\u6c7a\u7b56\u306e\u4e00\u90e8\u3092\u793a\u3057\u3066\u3044\u307e\u3059\u3002\uff09<\/p>\n<p><H3>\u9078\u629e\u9805\u76ee\uff08\u8907\u6570\uff09<\/H3><\/p>\n<p><input type=\"checkbox\" id=\"chk1\" name=\"chk1\" value=\"chk1\" \/> PATH<\/p>\n<p><input type=\"checkbox\" id=\"chk1\" name=\"chk1\" value=\"chk1\" \/> PATHITEM<\/p>\n<p><input type=\"checkbox\" id=\"chk1\" name=\"chk1\" value=\"chk1\" \/> EXCEPT<\/p>\n<p><input type=\"checkbox\" id=\"chk1\" name=\"chk1\" value=\"chk1\" \/> CROSSJOIN<\/p>\n<p><input type=\"checkbox\" id=\"chk1\" name=\"chk1\" value=\"chk1\" \/> RELATED<br \/>\n&nbsp;<\/p>\n<hr \/>\n<p>&nbsp;<br \/>\n<div id=\"rinkerid3910\" class=\"yyi-rinker-contents  yyi-rinker-postid-3910 yyi-rinker-img-m yyi-rinker-catid-127 \">\n\t<div class=\"yyi-rinker-box\">\n\t\t<div class=\"yyi-rinker-image\">\n\t\t\t\t\t\t\t<a href=\"https:\/\/www.amazon.co.jp\/dp\/B07N8NVYLV?tag=jackal13-22&#038;linkCode=ogi&#038;th=1&#038;psc=1\" rel=\"nofollow\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/m.media-amazon.com\/images\/I\/41xV98eK10L._SL160_.jpg\" width=\"112\" height=\"160\" class=\"yyi-rinker-main-img\" style=\"border: none;\"><\/a>\t\t\t\t\t<\/div>\n\t\t<div class=\"yyi-rinker-info\">\n\t\t\t<div class=\"yyi-rinker-title\">\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/www.amazon.co.jp\/dp\/B07N8NVYLV?tag=jackal13-22&#038;linkCode=ogi&#038;th=1&#038;psc=1\" rel=\"nofollow\">\u30d6\u30e9\u30c3\u30af\u4f01\u696d\u306e\u793e\u54e1\u304c\u732b\u306b\u306a\u3063\u3066\u4eba\u751f\u304c\u5909\u308f\u3063\u305f\u8a71\u3000\u30e2\u30d5\u7530\u304f\u3093\u306e\u5834\u5408 (\u30b3\u30df\u30c3\u30af\u30a8\u30c3\u30bb\u30a4)<\/a>\t\t\t\t\t\t\t<\/div>\n\t\t\t<div class=\"yyi-rinker-detail\">\n\t\t\t\t\t\t\t<div class=\"credit-box\">created by&nbsp;<a href=\"https:\/\/oyakosodate.com\/rinker\/\" rel=\"nofollow noopener\" target=\"_blank\" >Rinker<\/a><\/div>\n\t\t\t\t\t\t\t\t\t\t<div class=\"price-box\">\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<ul class=\"yyi-rinker-links\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<li class=\"amazonkindlelink\">\n\t\t\t\t\t\t<a href=\"https:\/\/www.amazon.co.jp\/dp\/B07N8NVYLV?tag=jackal13-22&amp;linkCode=ogi&amp;th=1&amp;psc=1\" rel=\"nofollow\" class=\"yyi-rinker-link\">Kindle<\/a>\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t                    <li class=\"amazonlink\">\n\t\t\t\t\t\t<a href=\"https:\/\/www.amazon.co.jp\/dp\/B07N8NVYLV?tag=jackal13-22&amp;linkCode=ogi&amp;th=1&amp;psc=1\" rel=\"nofollow\" class=\"yyi-rinker-link\">Amazon<\/a>\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<li class=\"rakutenlink\">\n\t\t\t\t\t\t<a href=\"https:\/\/hb.afl.rakuten.co.jp\/hgc\/2b289990.68b764ea.2b289991.0223a3f8\/Rinker_o_20230604164806?pc=https%3A%2F%2Fsearch.rakuten.co.jp%2Fsearch%2Fmall%2F%25E3%2583%2596%25E3%2583%25A9%25E3%2583%2583%25E3%2582%25AF%25E4%25BC%2581%25E6%25A5%25AD%25E3%2581%25AE%25E7%25A4%25BE%25E5%2593%25A1%25E3%2581%258C%25E7%258C%25AB%25E3%2581%25AB%25E3%2581%25AA%25E3%2581%25A3%25E3%2581%25A6%2F%3Ff%3D1%26grp%3Dproduct&amp;m=https%3A%2F%2Fsearch.rakuten.co.jp%2Fsearch%2Fmall%2F%25E3%2583%2596%25E3%2583%25A9%25E3%2583%2583%25E3%2582%25AF%25E4%25BC%2581%25E6%25A5%25AD%25E3%2581%25AE%25E7%25A4%25BE%25E5%2593%25A1%25E3%2581%258C%25E7%258C%25AB%25E3%2581%25AB%25E3%2581%25AA%25E3%2581%25A3%25E3%2581%25A6%2F%3Ff%3D1%26grp%3Dproduct\" rel=\"nofollow\" class=\"yyi-rinker-link\">\u697d\u5929\u5e02\u5834<\/a>\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<li class=\"yahoolink\">\n\t\t\t\t\t\t<a href=\"https:\/\/ck.jp.ap.valuecommerce.com\/servlet\/referral?sid=2742314&amp;pid=887951409&amp;vc_url=https%3A%2F%2Fshopping.yahoo.co.jp%2Fsearch%3Fp%3D%25E3%2583%2596%25E3%2583%25A9%25E3%2583%2583%25E3%2582%25AF%25E4%25BC%2581%25E6%25A5%25AD%25E3%2581%25AE%25E7%25A4%25BE%25E5%2593%25A1%25E3%2581%258C%25E7%258C%25AB%25E3%2581%25AB%25E3%2581%25AA%25E3%2581%25A3%25E3%2581%25A6\" rel=\"nofollow\" class=\"yyi-rinker-link\">Yahoo\u30b7\u30e7\u30c3\u30d4\u30f3\u30b0<\/a><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/ad.jp.ap.valuecommerce.com\/servlet\/gifbanner?sid=2742314&pid=887951409\" height=\"1\" width=\"1\" border=\"0\">\t\t\t\t\t<\/li>\n\t\t\t\t                \t\t\t\t\t\t\t\t\t\t\t<\/ul>\n\t\t\t\t\t<\/div>\n\t<\/div>\n<\/div>\n<br \/>\n&nbsp;<\/p>\n<hr \/>\n<p><H3>\u56de\u7b54<\/H3><\/p>\n<p>PATH<\/p>\n<p>PATHITEM<br \/>\n&nbsp;<\/p>\n<p><H4>\u56de\u7b54\u306e\u88dc\u8db3\u8aac\u660e<\/H4><\/p>\n<p>\u3053\u306ePATH\u95a2\u6570\u306f\u3001\u73fe\u5728\u306e\u8b58\u5225\u5b50\u306e\u3059\u3079\u3066\u306e\u89aa\u306e\u8b58\u5225\u5b50\u3092\u542b\u3080\u6587\u5b57\u5217\u3092\u8fd4\u3057\u307e\u3059\u3002\u3053\u308c\u306f\u30d5\u30e9\u30c3\u30c8\u5316\u306b\u4f7f\u7528\u3055\u308c\u307e\u3059\u3002<\/p>\n<p>\u3053\u306ePATHITEM\u95a2\u6570\u306f\u6587\u5b57\u5217\u306e\u6307\u5b9a\u3055\u308c\u305f\u4f4d\u7f6e\u306b\u3042\u308b\u9805\u76ee\u3092\u8fd4\u3057\u307e\u3059\u3002\u3053\u308c\u306f\u30d5\u30e9\u30c3\u30c8\u5316\u306b\u3082\u4f7f\u7528\u3055\u308c\u307e\u3059\u3002<\/p>\n<p>\u3053\u306eEXCEPT\u95a2\u6570\u306f\u3001\u3042\u308b\u30c6\u30fc\u30d6\u30eb\u304b\u3089\u5225\u306e\u30c6\u30fc\u30d6\u30eb\u306b\u5b58\u5728\u3057\u306a\u3044\u884c\u3092\u8fd4\u3059\u305f\u3081\u3001\u5225\u306e\u30c6\u30fc\u30d6\u30eb\u304c\u5fc5\u8981\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<p>\u3053\u306eCROSSJOIN\u95a2\u6570\u306f\u3001\u95a2\u6570\u304c\u53c2\u7167\u3059\u308b\u3059\u3079\u3066\u306e\u30c6\u30fc\u30d6\u30eb\u306e\u3059\u3079\u3066\u306e\u884c\u306e\u30c7\u30ab\u30eb\u30c8\u7a4d\u3092\u8fd4\u3057\u307e\u3059\u3002<\/p>\n<p>\u3053\u306eRELATED\u95a2\u6570\u306f\u5225\u306e\u30c6\u30fc\u30d6\u30eb\u304b\u3089\u95a2\u9023\u3059\u308b\u5024\u3092\u8fd4\u3057\u307e\u3059\u304c\u3001\u3053\u308c\u306b\u306f\u5225\u306e\u30c6\u30fc\u30d6\u30eb\u304c\u5fc5\u8981\u306b\u306a\u308a\u307e\u3059\u3002<br \/>\n&nbsp;<\/p>\n<h3>\u6b21\u306e\u554f\u984c<\/h3>\n<p><a href=\"https:\/\/memotarou.bulog.jp\/?p=4344\" data-blogcard=\"1\">\u3010PowerBI\u3011Q-039<\/a><\/p>\n<h3>\u8cc7\u683c\u53d6\u5f97<\/h3>\n<p><a href=\"https:\/\/memotarou.bulog.jp\/?p=3760\" data-blogcard=\"1\">PowerBI\u306e\u8cc7\u683c\u53d6\u5f97<\/a><\/p>\n<hr \/>\n","protected":false},"excerpt":{"rendered":"<p>\u554f\u984c \u554f\u984c.038 PowerBIDesktop\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u306b\u306f\u3001\u6b21\u306e\u5217\u3092\u6301\u3064\u5404\u5f93\u696d\u54e1\u306e\u884c\u3092\u542b\u3080Employees\u3068\u3044\u3046\u540d\u524d\u306e\u30c6\u30fc\u30d6\u30eb\u304c\u542b\u307e\u308c\u3066\u3044\u307e\u3059\u3002 \u30fb\u5f93\u696d\u54e1ID \u30fb\u5f93\u696d\u54e1\u540d \u30fb\u30de\u30cd\u30fc\u30b8\u30e3\u30fcID \u30fb\u30de\u30cd\u30fc\u30b8\u30e3\u30fc\u540d \u5404 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":4317,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[127],"tags":[],"class_list":["post-4315","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-127"],"_links":{"self":[{"href":"https:\/\/memotarou.bulog.jp\/index.php?rest_route=\/wp\/v2\/posts\/4315","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/memotarou.bulog.jp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/memotarou.bulog.jp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/memotarou.bulog.jp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/memotarou.bulog.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4315"}],"version-history":[{"count":2,"href":"https:\/\/memotarou.bulog.jp\/index.php?rest_route=\/wp\/v2\/posts\/4315\/revisions"}],"predecessor-version":[{"id":4347,"href":"https:\/\/memotarou.bulog.jp\/index.php?rest_route=\/wp\/v2\/posts\/4315\/revisions\/4347"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/memotarou.bulog.jp\/index.php?rest_route=\/wp\/v2\/media\/4317"}],"wp:attachment":[{"href":"https:\/\/memotarou.bulog.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4315"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/memotarou.bulog.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4315"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/memotarou.bulog.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4315"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}