Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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?
Solved! Go to 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
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
Thank for the reply @dufoq3 that fixed it! I did not know I needed to do a Step Back