Forum Discussion
Select a column based on a variable
Hi everyone!
I have been struggulling with the database at work and need some help. My date base consists in a table with a column named after days of the year and if the system is operative or inoperative on that day. Here's a print:
I need to find you if the system is working on the day I'm displaying it. ie: If I open the dashboard on the 12/01, I want to know how many systems are INOP on that day.
I've tried to convert the line in day of the year, creating a variable with the day of the year and using it to remove the column, but I was not successfull, as follows:
... continuation of the code ...
DayOfTheYear = Date.DayOfYear(DateTime.Date(DateTime.LocalNow())),
#"Removing all other columns" = Table.SelectColumns(DayOfTheYear, {"ACFT", Number.ToText(DayOfTheYear)}),
... continuation of the code ...
What am I doing it wrong?
Hi wayland, at step Parameter you can choose column.
Is this what you want?
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclTSUfIPQCJidaKVnGB8Tz8EBZJwxqbaBZdqV6wSsQA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [System = _t, #"10/01" = _t, #"11/01" = _t, #"12/01" = _t]), Parameter = "12/01", StepBack = Source, RemovedOtherColumns = Table.SelectColumns(StepBack,{"System", Parameter}) in RemovedOtherColumns
3 Replies
Hi wayland, at step Parameter you can choose column.
Is this what you want?
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclTSUfIPQCJidaKVnGB8Tz8EBZJwxqbaBZdqV6wSsQA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [System = _t, #"10/01" = _t, #"11/01" = _t, #"12/01" = _t]), Parameter = "12/01", StepBack = Source, RemovedOtherColumns = Table.SelectColumns(StepBack,{"System", Parameter}) in RemovedOtherColumns
