Excel + Power Query + Power BI商業數據分析-06.資料檢查排序日期資料

<div data-block="true" data-editor="g7j7" data-offset-key="ealr7-0-0" style="font-family: "Segoe UI Historic", "Segoe UI", Helvetica, Arial, sans-serif; color: rgb(5, 5, 5); font-size: 15px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"> Excel + Power Query + Power BI商業數據分析-06.資料檢查 排序日期資料:

利用排序，檢查資料完整性是否是我們要的時間區間

<div data-block="true" data-editor="g7j7" data-offset-key="3rpfm-0-0" style="font-family: "Segoe UI Historic", "Segoe UI", Helvetica, Arial, sans-serif; color: rgb(5, 5, 5); font-size: 15px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"> https://youtu.be/XAQ2Vz5nOsI

<div data-block="true" data-editor="g7j7" data-offset-key="dmoet-0-0" style="font-family: "Segoe UI Historic", "Segoe UI", Helvetica, Arial, sans-serif; color: rgb(5, 5, 5); font-size: 15px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"> 範例與講義下載: https://goo.gl/ytzRxT

<div data-block="true" data-editor="g7j7" data-offset-key="de1l4-0-0" style="font-family: "Segoe UI Historic", "Segoe UI", Helvetica, Arial, sans-serif; color: rgb(5, 5, 5); font-size: 15px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"> 如果影片對你有幫助，記得訂閱並加入【孫在陽】頻道

<div data-block="true" data-editor="g7j7" data-offset-key="cm2a1-0-0" style="font-family: "Segoe UI Historic", "Segoe UI", Helvetica, Arial, sans-serif; color: rgb(5, 5, 5); font-size: 15px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"> https://www.youtube.com/c/KemSun/fe...

<div data-block="true" data-editor="g7j7" data-offset-key="34hq-0-0" style="font-family: "Segoe UI Historic", "Segoe UI", Helvetica, Arial, sans-serif; color: rgb(5, 5, 5); font-size: 15px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"> #零基礎學電腦 #OFFICE #電腦教學 #免費學習 #大數據分析 #GOOGLE #VBA自動

<div data-block="true" data-editor="g7j7" data-offset-key="b8omu-0-0" style="font-family: "Segoe UI Historic", "Segoe UI", Helvetica, Arial, sans-serif; color: rgb(5, 5, 5); font-size: 15px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"> 蝦皮賣場:https://shopee.tw/a0829kimo

零基礎學電腦

介紹分享資訊安全及office 各項使用技巧／免費電腦教學