LuanExcel

let
    Fonte = Excel.CurrentWorkbook(){[Name="Tabela2"]}[Content],
    #"Tipo Alterado" = Table.TransformColumnTypes(Fonte,{{"DATA", type date}, {"OrdemServico", Int64.Type}, {"Descricao", type text}}),
    LinhaAdicionado = Table.AddIndexColumn(#"Tipo Alterado", "Linha", 1, 1, Int64.Type),
    Group = Table.Group(LinhaAdicionado, {"OrdemServico"}, {{"Contagem", each List.Max([Linha]), type number}}),
    Mesc = Table.NestedJoin(LinhaAdicionado, {"Linha"}, Group, {"Contagem"}, "Linhas Agrupadas", JoinKind.Inner),
    Remov = Table.RemoveColumns(Mesc,{"Linha", "Linhas Agrupadas"})
in
    Remov

LuanExcel

let
 Fonte = [
 l =List.Select(
 List.Transform(
 {Number.From(Date.From( #date (2022, 1, 1)))..Number.From(Date.From( #date (2022, 12, 31)))},each Date.From(_)), 
 each Date.Day(_) > 25)
 ][l], 
 tab = Table.FromList(Fonte, Splitter.SplitByNothing(), null, null, ExtraValues.Error), 
 Segunda = Table.RenameColumns(
 Table.SelectRows(

LuanExcel

//Solucao_Luan_Excel 74


let
    Fonte = Data,
    g1 = Table.Group(Fonte, {"Winners"}, {
        {"Contagem", each 
        Table.FromColumns(
        {[Year]} & {{null} & List.RemoveLastN([Year],1)})}
         }),

LuanExcel

Fontos

LuanExcel

let
    Fonte = Tabela1,
    cond = Table.AddColumn(Fonte, "Personalizar", each if [Seq] = "#" then [Question] else null),
    pb = Table.FillDown(cond,{"Personalizar"}),
    gp = Table.Group(pb, {"Personalizar"}, {{"Contagem", each 
    [
    a = Table.RemoveFirstN(_,1)[[Question],[Correct]],
    b = Table.AddColumn(a,"Correct Answer",each if [Correct] = "Y" then [Question] else null )
    ]
}}),

LuanExcel

9C:FC:E8:F1:EC:FD
7A:79:19:34:1B:5B
A4:63:A1:6C:1B:84
6C:94:66:44:76:72

LuanExcel

Acumular:
--------------------------------------------------------------------------------
let
    a = {13.47, 9.45},
    b = List.Accumulate(
            {1..List.Count(a)-1},
            {a{0}},
            (s, c) => s & {a{c} + List.Last(s)}
        )
in

LuanExcel

--------------------------------------------------------------------------------

Acumular:
--------------------------------------------------------------------------------    
LValores = List.Buffer(tbl[Sales]),

    Acum = List.Generate(
                    () => [Counter = 0, Valor = LValores{0}],
                    each [Counter] < List.Count(LValores), // Total Registros = 4013
                    each [

LuanExcel

tes

LuanExcel

Imagens