[下載課程影片] Power BI 入門教學 #4 對比數據 | 去年同期對比 YoY Change | 同業分析對比 Peer Analysis

本影片以廣東話提供Power BI教學，會由淺入深以練習形式協助觀眾可以輕鬆掌握Power BI的應用。

 教學內容包括以下：

1.         修改資料來源路徑

2.         匯入數據

3.         學習複製M Script 簡化重複的步驟

4.         建立Date Bridge 橋樑連結數據

5.         處理Granularity Discrepancies

6.         建立Measures

7.         建立同業比較分析報表

let

    Source = List.Dates(#date(2019,1,1), Duration.Days(#date(2023,1,1) - #date(2019,1,1)), #duration(1,0,0,0)),

    #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),

    #"Renamed Columns" = Table.RenameColumns(#"Converted to Table",{{"Column1", "DateKey"}}),

    #"Added Custom" = Table.AddColumn(#"Renamed Columns", "Year", each Date.Year([DateKey])),

    #"Added Custom1" = Table.AddColumn(#"Added Custom", "Month Number", each Date.Month([DateKey])),

    #"Added Custom2" = Table.AddColumn(#"Added Custom1", "Month Number 2", each Date.ToText([DateKey], "MM")),

    #"Added Custom3" = Table.AddColumn(#"Added Custom2", "Day", each Date.Day([DateKey])),

    #"Added Custom4" = Table.AddColumn(#"Added Custom3", "Day Name", each Date.ToText([DateKey], "ddd")),

    #"Added Custom5" = Table.AddColumn(#"Added Custom4", "Month Name", each Date.ToText([DateKey], "MMM")),

    #"Added Custom6" = Table.AddColumn(#"Added Custom5", "Quarter Number", each Date.QuarterOfYear([DateKey])),

    #"Added Custom7" = Table.AddColumn(#"Added Custom6", "Quarter", each "Qtr"& Number.ToText([Quarter Number])),

    #"Added Custom8" = Table.AddColumn(#"Added Custom7", "WeekMonth", each Date.WeekOfMonth([DateKey])),

    #"Added Custom9" = Table.AddColumn(#"Added Custom8", "Week", each "Week" & Number.ToText([WeekMonth]))

in

    #"Added Custom9"