Hola
Este código M funciona
let
Source = Excel.CurrentWorkbook(){[Name="Data"]}[Content],
#"Inserted year and quarter" = Table.AddColumn(Source, "Year-Quarter", each Text.From(Date.Year([FileDate]))&" Q-"&Text.From(Date.QuarterOfYear([FileDate]))),
#"Grouped Rows" = Table.Group(#"Inserted year and quarter", {"Year-Quarter"}, {{"Count", each Table.SelectRows(Table.AddRankColumn(_,"Rank",{"FileDate", Order.Descending},[RankKind = RankKind.Competition]),each [Rank]<2)}}),
#"Expanded Count" = Table.ExpandTableColumn(#"Grouped Rows", "Count", {"FileName", "FileDate", "Level ", "Value "}, {"FileName", "FileDate", "Level ", "Value "})
in
#"Expanded Count"Espero que esto ayude.
Hola
Este código M funciona
let
Source = Excel.CurrentWorkbook(){[Name="Data"]}[Content],
#"Inserted year and quarter" = Table.AddColumn(Source, "Year-Quarter", each Text.From(Date.Year([FileDate]))&" Q-"&Text.From(Date.QuarterOfYear([FileDate]))),
#"Grouped Rows" = Table.Group(#"Inserted year and quarter", {"Year-Quarter"}, {{"Count", each Table.SelectRows(Table.AddRankColumn(_,"Rank",{"FileDate", Order.Descending},[RankKind = RankKind.Competition]),each [Rank]<2)}}),
#"Expanded Count" = Table.ExpandTableColumn(#"Grouped Rows", "Count", {"FileName", "FileDate", "Level ", "Value "}, {"FileName", "FileDate", "Level ", "Value "})
in
#"Expanded Count"Espero que esto ayude.
¿Cuál es tu definición de una moneda de veinticinco centavos?
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("jZLJagMxDIZfpcw5rhavc0xIAiGHkENCFoaeWij0/c+Vp7arKRQ8DD/IfBK/ludz+Pj8en9Da5BfGdm9yDesBrSADOVB4u1WxLlhWvVmbDYi1qqM0SDlDJ/pEZCgBOu1CGEPer9nlBXKxceMcvGQg/1ehEMPermIBP+LcjBoK8oBpLkS/LSFPej5LDImZSAZdM1AAnQVPRzyePWwyKBvKAH6ip5OIl4bkLZCMyBthYrOSwujqhoNxlY1gvwluN1EoqpKst9UUZLdpoo+HiJJtWXR4FhRiyAL04u1rge9Xucb0EfgDWEz64FwUTbGHnS3+zNYIkPttIiAaNFXVChbQ+1e2ALx4gj0Ff6PHo95XTRM0zc=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [FileName = _t, FileDate = _t, #"Level " = _t, #"Value " = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"FileName", type text}, {"FileDate", type date}, {"Level ", type text}, {"Value ", Int64.Type}},"en-GB"),
#"Added Custom" = Table.AddColumn(#"Changed Type", "Quarter", each Text.From(Date.Year([FileDate])) & "-Q" & Text.From(Date.QuarterOfYear([FileDate])),type text),
#"Grouped Rows" = Table.Group(#"Added Custom", {"Quarter"}, {{"Max Date", each List.Max([FileDate]), type nullable date}, {"Rows", each _, type table [FileName=nullable text, FileDate=nullable date, #"Level "=nullable text, #"Value "=nullable number, Quarter=text]}}),
#"Expanded Rows" = Table.ExpandTableColumn(#"Grouped Rows", "Rows", {"FileName", "FileDate", "Level ", "Value "}, {"FileName", "FileDate", "Level ", "Value "}),
#"Filtered Rows" = Table.SelectRows(#"Expanded Rows", each [FileDate] = [Max Date]),
#"Removed Columns" = Table.RemoveColumns(#"Filtered Rows",{"Max Date"})
in
#"Removed Columns"Cómo usar este código: Cree una nueva consulta en blanco. Haga clic en "Editor avanzado". Reemplace el código de la ventana por el código que se proporciona aquí. Haga clic en "Listo". Una vez que haya examinado el código, reemplace todo el paso Origen por su propio origen.
Helpful resources
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
