Created
March 9, 2024 17:01
-
-
Save NonAbility/d268ee75223c85d48a2adf8e00f429c1 to your computer and use it in GitHub Desktop.
Q_Read_CSV_RealTimeクエリーを参照して、一番最後のDate_Timeを取得するクエリー
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
let | |
ソース = Q_Read_CSV_RealTime, | |
削除された他の列 = Table.SelectColumns(ソース,{"Date_Time"}), | |
並べ替えられた行 = Table.Sort(削除された他の列,{{"Date_Time", Order.Descending}}), | |
No = Table.AddIndexColumn(並べ替えられた行, "No", 1, 1, Int64.Type), | |
フィルターされた行 = Table.SelectRows(No, each [No] = 1), | |
削除された他の列1 = Table.SelectColumns(フィルターされた行,{"No", "Date_Time"}) | |
in | |
削除された他の列1 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment