PowerQuery “YYYYMM” to date 2020.10.272020.11.04 =Date.FromText( Text.Range([年月], 0,4) & "-" &Text.Range([年月], 4,2) )