PowerQuery yyyymmdd to End of Month 月末 2020.12.04 Date.AddDays(Date.AddMonths( Date.From(Text.From(20201201)),1),-1) )