-
类型转换
转换成Text型：Text.From(转换值) 从Date型取得年：Date.Year(日期值) 从Date型取得月：Date.Month(日期值) 从Date型取得日：Date.Day(日期值)https://learn.microsoft.com/ja-jp/powerquery-m/date-functions
-
将不同的列连在一起，形式为：列1_列2_列3
Text.Combine({[列1], [列2], [列3]}, "_")
Register as a new user and use Qiita more conveniently
- You get articles that match your needs
- You can efficiently read back useful information
- You can use dark theme