Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hola a todos,
Necesita ayuda para excluir fechas de fin de semana de una columna de fecha en power query editor.
Gracias de antemano
Solved! Go to Solution.
Aquí está la versión simple.
Ver más abajo y adjunto. Básicamente, agregue una columna DayOfWeekName basada en su fecha y filtre desde allí.
let
start = Number.From(#date(2021, 1, 1)),
end = Number.From(#date(2021, 12, 31)),
Source = {start .. end},
#"Converted to Table" = Table.FromList(
Source,
Splitter.SplitByNothing(),
null,
null,
ExtraValues.Error
),
#"Changed Type" = Table.TransformColumnTypes(#"Converted to Table", {{"Column1", type date}}),
#"Renamed Columns" = Table.RenameColumns(#"Changed Type", {{"Column1", "Date"}}),
#"Inserted Day Name" = Table.AddColumn(
#"Renamed Columns",
"Day Name",
each Date.DayOfWeekName([Date]),
type text
),
#"Filtered Rows" = Table.SelectRows(
#"Inserted Day Name",
each ([Day Name] <> "Saturday" and [Day Name] <> "Sunday")
)
in
#"Filtered Rows"
Aquí está la versión simple.
Ver más abajo y adjunto. Básicamente, agregue una columna DayOfWeekName basada en su fecha y filtre desde allí.
let
start = Number.From(#date(2021, 1, 1)),
end = Number.From(#date(2021, 12, 31)),
Source = {start .. end},
#"Converted to Table" = Table.FromList(
Source,
Splitter.SplitByNothing(),
null,
null,
ExtraValues.Error
),
#"Changed Type" = Table.TransformColumnTypes(#"Converted to Table", {{"Column1", type date}}),
#"Renamed Columns" = Table.RenameColumns(#"Changed Type", {{"Column1", "Date"}}),
#"Inserted Day Name" = Table.AddColumn(
#"Renamed Columns",
"Day Name",
each Date.DayOfWeekName([Date]),
type text
),
#"Filtered Rows" = Table.SelectRows(
#"Inserted Day Name",
each ([Day Name] <> "Saturday" and [Day Name] <> "Sunday")
)
in
#"Filtered Rows"
Networkdays, por favor vea el siguiente enlace:
https://www.thebiccountant.com/2020/02/20/date-networkdays-function-for-power-query-and-power-bi/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
1 | |
1 | |
1 | |
1 | |
1 |