Select a column based on a variable

[wayland]

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?

[dufoq3 · Accepted solution]

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

[wayland]

Thank for the reply @dufoq3 that fixed it! I did not know I needed to do a Step Back

[dufoq3]

You don't need StepBack because i.e in RemovedOtherColumns I could refer directly to Source, but with StepBack it is easier to read for you 😉