{"id":3868,"date":"2023-06-05T11:40:24","date_gmt":"2023-06-05T02:40:24","guid":{"rendered":"https:\/\/memotarou.bulog.jp\/?p=3868"},"modified":"2023-06-13T11:37:44","modified_gmt":"2023-06-13T02:37:44","slug":"data-analysis-powerbi-dax","status":"publish","type":"post","link":"https:\/\/memotarou.bulog.jp\/?p=3868","title":{"rendered":"\u3010\u30c7\u30fc\u30bf\u5206\u6790\u3011PowerBI\u306eDAX\u95a2\u6570\u3068\u306f\uff1f"},"content":{"rendered":"<h2>PowerBI\u306eDAX\u95a2\u6570<\/h2>\n<div align=\"center\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/06\/data-analysis-powerbi-dax.jpg\" alt=\"\" width=\"600\" height=\"600\" class=\"alignnone size-full wp-image-3869\" srcset=\"https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/06\/data-analysis-powerbi-dax.jpg 600w, https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/06\/data-analysis-powerbi-dax-300x300.jpg 300w, https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/06\/data-analysis-powerbi-dax-150x150.jpg 150w, https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/06\/data-analysis-powerbi-dax-75x75.jpg 75w, https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/06\/data-analysis-powerbi-dax-100x100.jpg 100w, https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/06\/data-analysis-powerbi-dax-530x530.jpg 530w, https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/06\/data-analysis-powerbi-dax-565x565.jpg 565w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/div>\n<h3>DAX\u95a2\u6570\u3068\u306f\uff1f<\/h3>\n<p>DAX\u306f\u300eData Analysis Expressions\u300f\u306e\u7565\u3067\u3059\u3002<\/p>\n<p>DAX\u95a2\u6570\u306f\u3001PowerBI\u3084Excel\u306ePowerPivot\u306a\u3069\u3001Microsoft\u306e\u30c7\u30fc\u30bf\u30e2\u30c7\u30ea\u30f3\u30b0\u30c4\u30fc\u30eb\u3067\u4f7f\u7528\u3055\u308c\u308b\u5f0f\u8a00\u8a9e\u3067\u3001<br \/>\n&nbsp;<\/p>\n<div class=\"mybox-border\">\n<ul>\n<li>\u30c7\u30fc\u30bf\u306e\u64cd\u4f5c<\/li>\n<li>\u8a08\u7b97<\/li>\n<li>\u96c6\u8a08<\/li>\n<li>\u30d5\u30a3\u30eb\u30bf\u30ea\u30f3\u30b0<\/li>\n<\/ul>\n<\/div>\n<p>&nbsp;<br \/>\n\u306a\u3069\u306e\u69d8\u3005\u306a\u30bf\u30b9\u30af\u3092\u5b9f\u884c\u3059\u308b\u305f\u3081\u306b\u4f7f\u7528\u3055\u308c\u308b\u95a2\u6570\u306e\u96c6\u5408\u3092\u7dcf\u79f0\u3057\u305f\u540d\u79f0\u3067\u3059\u3002<br \/>\n&nbsp;<\/p>\n<h3>\u3088\u304f\u4f7f\u308f\u308c\u308bDAX\u95a2\u6570<\/h3>\n<h4>SUM<\/h4>\n<p>\u6307\u5b9a\u3055\u308c\u305f\u5217\u306e\u6570\u5024\u306e\u5408\u8a08\u3092\u8a08\u7b97\u3057\u307e\u3059\u3002<\/p>\n<div class=\"mybox-example\">\nSUM(Table[Column])\n<\/div>\n<p>&nbsp;<\/p>\n<h4>AVERAGE<\/h4>\n<p>\u6307\u5b9a\u3055\u308c\u305f\u5217\u306e\u6570\u5024\u306e\u5e73\u5747\u5024\u3092\u8a08\u7b97\u3057\u307e\u3059\u3002<\/p>\n<div class=\"mybox-example\">\nAVERAGE(Table[Column])\n<\/div>\n<p>&nbsp;<\/p>\n<h4>COUNT<\/h4>\n<p>\u6307\u5b9a\u3055\u308c\u305f\u5217\u306e\u975e\u7a7a\u306e\u884c\u6570\u3092\u8a08\u7b97\u3057\u307e\u3059\u3002<\/p>\n<div class=\"mybox-example\">\nCOUNT(Table[Column])\n<\/div>\n<p>&nbsp;<\/p>\n<h4>MAX<\/h4>\n<p>\u6307\u5b9a\u3055\u308c\u305f\u5217\u306e\u6700\u5927\u5024\u3092\u8fd4\u3057\u307e\u3059\u3002<\/p>\n<div class=\"mybox-example\">\nMAX(Table[Column])\n<\/div>\n<p>&nbsp;<\/p>\n<h4>MIN<\/h4>\n<p>\u6307\u5b9a\u3055\u308c\u305f\u5217\u306e\u6700\u5c0f\u5024\u3092\u8fd4\u3057\u307e\u3059\u3002<\/p>\n<div class=\"mybox-example\">\nMIN(Table[Column])\n<\/div>\n<p>&nbsp;<\/p>\n<h4>CALCULATE<\/h4>\n<p>\u6307\u5b9a\u3055\u308c\u305f\u5f0f\u3092\u8a55\u4fa1\u3057\u3001\u6307\u5b9a\u3055\u308c\u305f\u30d5\u30a3\u30eb\u30bf\u30fc\u6761\u4ef6\u3092\u9069\u7528\u3057\u307e\u3059\u3002<\/p>\n<div class=\"mybox-example\">\nCALCULATE(SUM(Table[Column]), Table[Category] = &#8220;CategoryA&#8221;)\n<\/div>\n<p>&nbsp;<\/p>\n<h4>IF<\/h4>\n<p>\u6761\u4ef6\u306b\u57fa\u3065\u3044\u3066\u7d50\u679c\u3092\u8fd4\u3057\u307e\u3059\u3002<\/p>\n<div class=\"mybox-example\">\nIF(Table[Value] > 10, &#8220;High&#8221;, &#8220;Low&#8221;)\n<\/div>\n<p>&nbsp;<\/p>\n<h3>\u65e5\u4ed8\u3092\u64cd\u4f5c\u3059\u308bDAX\u95a2\u6570<\/h3>\n<h4>TODAY<\/h4>\n<p>\u73fe\u5728\u306e\u65e5\u4ed8\u3092\u8fd4\u3057\u307e\u3059\u3002<\/p>\n<div class=\"mybox-example\">\nTODAY()\n<\/div>\n<h4>DATE<\/h4>\n<p>\u5e74\u3001\u6708\u3001\u65e5\u306e\u5024\u304b\u3089\u65e5\u4ed8\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n<div class=\"mybox-example\">\nDATE(2023, 6, 2)\n<\/div>\n<p>&nbsp;<\/p>\n<h4>YEAR<\/h4>\n<p>\u65e5\u4ed8\u304b\u3089\u5e74\u3092\u62bd\u51fa\u3057\u307e\u3059\u3002<\/p>\n<div class=\"mybox-example\">\nYEAR(DateColumn)\n<\/div>\n<p>&nbsp;<\/p>\n<h4>MONTH<\/h4>\n<p>\u65e5\u4ed8\u304b\u3089\u6708\u3092\u62bd\u51fa\u3057\u307e\u3059\u3002<\/p>\n<div class=\"mybox-example\">\nMONTH(DateColumn)\n<\/div>\n<p>&nbsp;<\/p>\n<h4>DAY<\/h4>\n<p>\u65e5\u4ed8\u304b\u3089\u65e5\u3092\u62bd\u51fa\u3057\u307e\u3059\u3002<\/p>\n<div class=\"mybox-example\">\nDAY(DateColumn)\n<\/div>\n<p>&nbsp;<\/p>\n<h4>EOMONTH<\/h4>\n<p>\u65e5\u4ed8\u306e\u672b\u65e5\uff08\u6708\u672b\uff09\u3092\u8fd4\u3057\u307e\u3059\u3002<\/p>\n<div class=\"mybox-example\">\nEOMONTH(DateColumn, 0)\n<\/div>\n<p>&nbsp;<\/p>\n<h4>DATEDIFF<\/h4>\n<p>2\u3064\u306e\u65e5\u4ed8\u9593\u306e\u5dee\u3092\u6307\u5b9a\u3057\u305f\u5358\u4f4d\u3067\u8a08\u7b97\u3057\u307e\u3059\uff08\u65e5\u3001\u6708\u3001\u5e74\u306a\u3069\uff09\u3002<\/p>\n<div class=\"mybox-example\">\nDATEDIFF(StartDate, EndDate, DAY)\n<\/div>\n<p>&nbsp;<\/p>\n<h4>CALENDARAUTO<\/h4>\n<p>\u30c7\u30fc\u30bf\u5185\u306e\u65e5\u4ed8\u7bc4\u56f2\u306b\u57fa\u3065\u3044\u3066\u81ea\u52d5\u7684\u306b\u30ab\u30ec\u30f3\u30c0\u30fc\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n<div class=\"mybox-example\">\nCALENDARAUTO()\n<\/div>\n<p>&nbsp;<\/p>\n<h3>DAX\u95a2\u6570\u306e\u4f7f\u3044\u65b9\u4e00\u4f8b<\/h3>\n<p>DAX\u95a2\u6570\u306e\u4f7f\u3044\u65b9\u3068\u3057\u3066\u3001Count\u95a2\u6570\uff08\u30ab\u30a6\u30f3\u30c8\u95a2\u6570\uff09\u3092\u4e00\u4f8b\u3068\u3057\u3066\u8aac\u660e\u3057\u307e\u3059\u3002<\/p>\n<p>\u4e0b\u8a18\u306e\u3088\u3046\u306a\u90f5\u4fbf\u756a\u53f7\u4e00\u89a7\u30c6\u30fc\u30d6\u30eb\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<p>\uff08\u3061\u306a\u307f\u306b\u4e0b\u8a18\u306e\u30c7\u30fc\u30bf\u306f\u3001\u90f5\u4fbf\u5c40\u306e\u30db\u30fc\u30e0\u30da\u30fc\u30b8\u304b\u3089\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3067\u304d\u308b\u30c7\u30fc\u30bf\u3067\u3059\u3002\uff09<br \/>\n<a href=\"https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/06\/data-analysis-powerbi-dax1.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/06\/data-analysis-powerbi-dax1-300x234.jpg\" alt=\"\" width=\"300\" height=\"234\" class=\"alignnone size-medium wp-image-3875\" srcset=\"https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/06\/data-analysis-powerbi-dax1-300x234.jpg 300w, https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/06\/data-analysis-powerbi-dax1-1024x800.jpg 1024w, https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/06\/data-analysis-powerbi-dax1-768x600.jpg 768w, https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/06\/data-analysis-powerbi-dax1-530x414.jpg 530w, https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/06\/data-analysis-powerbi-dax1-565x442.jpg 565w, https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/06\/data-analysis-powerbi-dax1-710x555.jpg 710w, https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/06\/data-analysis-powerbi-dax1-725x567.jpg 725w, https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/06\/data-analysis-powerbi-dax1.jpg 1039w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>\u3053\u306e\u30c6\u30fc\u30d6\u30eb\u30c7\u30fc\u30bf\u3092\u4f7f\u3063\u3066\u3001\u30c0\u30c3\u30b7\u30e5\u30dc\u30fc\u30c9\u3067\u30c6\u30fc\u30d6\u30eb\u3092\u8868\u793a\u3057\u3001\u90fd\u9053\u5e9c\u770c\u3054\u3068\u306b\u90f5\u4fbf\u756a\u53f7\u304c\u4f55\u4ef6\u3042\u308b\u306e\u304b\uff1f\u3092\u62bd\u51fa\u3059\u308b\u65b9\u6cd5\u3067\u8aac\u660e\u3057\u307e\u3059\u3002<\/p>\n<p>\u5b8c\u6210\u56f3\u304c\u3053\u3061\u3089\u3002<\/p>\n<p><a href=\"https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/06\/data-analysis-powerbi-dax2.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/06\/data-analysis-powerbi-dax2-248x300.jpg\" alt=\"\" width=\"248\" height=\"300\" class=\"alignnone size-medium wp-image-3876\" srcset=\"https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/06\/data-analysis-powerbi-dax2-248x300.jpg 248w, https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/06\/data-analysis-powerbi-dax2-438x530.jpg 438w, https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/06\/data-analysis-powerbi-dax2-467x565.jpg 467w, https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/06\/data-analysis-powerbi-dax2-587x710.jpg 587w, https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/06\/data-analysis-powerbi-dax2-599x725.jpg 599w, https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/06\/data-analysis-powerbi-dax2.jpg 665w\" sizes=\"auto, (max-width: 248px) 100vw, 248px\" \/><\/a><\/p>\n<p>\u30c6\u30fc\u30d6\u30eb\u306b\u300c\u90fd\u9053\u5e9c\u770c\u540d\u300d\u304c\u8868\u793a\u3055\u308c\u308b\u3088\u3046\u306b\u8a2d\u5b9a\u3057\u3001\u65b0\u3057\u3044\u5217\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002<\/p>\n<p><a href=\"https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/06\/data-analysis-powerbi-dax3.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/06\/data-analysis-powerbi-dax3-247x300.jpg\" alt=\"\" width=\"247\" height=\"300\" class=\"alignnone size-medium wp-image-3877\" srcset=\"https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/06\/data-analysis-powerbi-dax3-247x300.jpg 247w, https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/06\/data-analysis-powerbi-dax3-436x530.jpg 436w, https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/06\/data-analysis-powerbi-dax3.jpg 447w\" sizes=\"auto, (max-width: 247px) 100vw, 247px\" \/><\/a><\/p>\n<p>\u65b0\u3057\u3044\u5217\u306f\u3001\u53f3\u5074\u306e\u30c7\u30fc\u30bf\u6b04\u306e\u30c6\u30fc\u30d6\u30eb\u540d\u3092\u53f3\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u30e1\u30cb\u30e5\u30fc\u304c\u51fa\u3066\u304f\u308b\u306e\u3067\u3001\u300c\u65b0\u3057\u3044\u5217\u300d\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n<p><a href=\"https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/06\/data-analysis-powerbi-dax4.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/06\/data-analysis-powerbi-dax4-300x238.jpg\" alt=\"\" width=\"300\" height=\"238\" class=\"alignnone size-medium wp-image-3878\" srcset=\"https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/06\/data-analysis-powerbi-dax4-300x238.jpg 300w, https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/06\/data-analysis-powerbi-dax4-530x421.jpg 530w, https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/06\/data-analysis-powerbi-dax4-565x449.jpg 565w, https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/06\/data-analysis-powerbi-dax4.jpg 636w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>\u5de6\u4e0a\u306b\u51fa\u3066\u304d\u305f\u6b04\u306b\u3001\u5217\u540d\u3092\u6307\u5b9a\u3057\u3001DAX\u95a2\u6570\u3067\u5f0f\u3092\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n<p><a href=\"https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/06\/data-analysis-powerbi-dax5.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/06\/data-analysis-powerbi-dax5-300x247.jpg\" alt=\"\" width=\"300\" height=\"247\" class=\"alignnone size-medium wp-image-3879\" srcset=\"https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/06\/data-analysis-powerbi-dax5-300x247.jpg 300w, https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/06\/data-analysis-powerbi-dax5-530x436.jpg 530w, https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/06\/data-analysis-powerbi-dax5-565x465.jpg 565w, https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/06\/data-analysis-powerbi-dax5.jpg 639w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>\u300c\u90f5\u4fbf\u756a\u53f7\u2017\u4ef6\u6570 = COUNT(&#8216;\u90f5\u4fbf\u756a\u53f7\u4e00\u89a7'[\u90fd\u9053\u5e9c\u770c\u540d])\u300d<\/p>\n<p>\u3068\u5165\u529b\u3057\u305f\u5217\u304c\u73fe\u308c\u3001\u90fd\u9053\u5e9c\u770c\u3054\u3068\u306b\u90f5\u4fbf\u756a\u53f7\u306e\u4f55\u4ef6\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n<div id=\"rinkerid3771\" class=\"yyi-rinker-contents  yyi-rinker-postid-3771 yyi-rinker-img-m yyi-rinker-catid-126 yyi-rinker-catid-122 yyi-rinker-catid-1 \">\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:\/\/hb.afl.rakuten.co.jp\/hgc\/g00q072b.z3ki8883.g00q072b.z3ki9a88\/Rinker_i_20230530135402?pc=https%3A%2F%2Fitem.rakuten.co.jp%2Fbook%2F16157046%2F&#038;m=http%3A%2F%2Fm.rakuten.co.jp%2Fbook%2Fi%2F19870101%2F&#038;rafcid=wsc_i_is_1051687256164779118\" rel=\"nofollow\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/thumbnail.image.rakuten.co.jp\/@0_mall\/book\/cabinet\/8033\/9784295008033.jpg?_ex=128x128\" width=\"128\" height=\"128\" 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:\/\/hb.afl.rakuten.co.jp\/hgc\/g00q072b.z3ki8883.g00q072b.z3ki9a88\/Rinker_t_20230530135402?pc=https%3A%2F%2Fitem.rakuten.co.jp%2Fbook%2F16157046%2F&#038;m=http%3A%2F%2Fm.rakuten.co.jp%2Fbook%2Fi%2F19870101%2F&#038;rafcid=wsc_i_is_1051687256164779118\" rel=\"nofollow\">\u3067\u304d\u308bPower\u3000BI \u30c7\u30fc\u30bf\u96c6\u8a08\u30fb\u5206\u6790\u30fb\u53ef\u8996\u5316\u30ce\u30a6\u30cf\u30a6\u304c\u8eab\u306b\u4ed8\u304f\u672c [ \u5965\u7530\u7406\u6075 ]<\/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                    <li class=\"amazonlink\">\n\t\t\t\t\t\t<a href=\"https:\/\/www.amazon.co.jp\/gp\/search?ie=UTF8&amp;keywords=PowerBI&amp;tag=jackal13-22&amp;index=blended&amp;linkCode=ure&amp;creative=6339\" 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\/g00q072b.z3ki8883.g00q072b.z3ki9a88\/Rinker_t_20230530135402?pc=https%3A%2F%2Fitem.rakuten.co.jp%2Fbook%2F16157046%2F&amp;m=http%3A%2F%2Fm.rakuten.co.jp%2Fbook%2Fi%2F19870101%2F&amp;rafcid=wsc_i_is_1051687256164779118\" 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%3DPowerBI\" 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\n","protected":false},"excerpt":{"rendered":"<p>PowerBI\u306eDAX\u95a2\u6570 DAX\u95a2\u6570\u3068\u306f\uff1f DAX\u306f\u300eData Analysis Expressions\u300f\u306e\u7565\u3067\u3059\u3002 DAX\u95a2\u6570\u306f\u3001PowerBI\u3084Excel\u306ePowerPivot\u306a\u3069\u3001Microsoft\u306e\u30c7\u30fc\u30bf\u30e2\u30c7\u30ea [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":3869,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[126,122,1],"tags":[124,125],"class_list":["post-3868","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-powerbi","category-122","category-memo","tag-124","tag-125"],"_links":{"self":[{"href":"https:\/\/memotarou.bulog.jp\/index.php?rest_route=\/wp\/v2\/posts\/3868","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=3868"}],"version-history":[{"count":2,"href":"https:\/\/memotarou.bulog.jp\/index.php?rest_route=\/wp\/v2\/posts\/3868\/revisions"}],"predecessor-version":[{"id":4057,"href":"https:\/\/memotarou.bulog.jp\/index.php?rest_route=\/wp\/v2\/posts\/3868\/revisions\/4057"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/memotarou.bulog.jp\/index.php?rest_route=\/wp\/v2\/media\/3869"}],"wp:attachment":[{"href":"https:\/\/memotarou.bulog.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3868"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/memotarou.bulog.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3868"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/memotarou.bulog.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3868"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}