LuanRodrigues LuanExcel
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Imagens |
LuanExcel
/ gist:584f6abc867c0d76e656ff640541b288
Created
March 13, 2024 17:03
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| tes |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -------------------------------------------------------------------------------- | |
| Acumular: | |
| -------------------------------------------------------------------------------- | |
| LValores = List.Buffer(tbl[Sales]), | |
| Acum = List.Generate( | |
| () => [Counter = 0, Valor = LValores{0}], | |
| each [Counter] < List.Count(LValores), // Total Registros = 4013 | |
| each [ |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 9C:FC:E8:F1:EC:FD | |
| 7A:79:19:34:1B:5B | |
| A4:63:A1:6C:1B:84 | |
| 6C:94:66:44:76:72 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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
/ gist:64fbb53c950f79d4257e90476147ed13
Created
February 6, 2023 23:45
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Fontos |
LuanExcel
/ Desafio_Excel_74
Last active
November 28, 2022 21:52
//Pontos Pricnipais: //Cálculo da primeira linha com a linha de baixo em Listas //Usar o ??0 para um cálculo entre um numero e o null
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| //Solucao_Luan_Excel 74 | |
| let | |
| Fonte = Data, | |
| g1 = Table.Group(Fonte, {"Winners"}, { | |
| {"Contagem", each | |
| Table.FromColumns( | |
| {[Year]} & {{null} & List.RemoveLastN([Year],1)})} | |
| }), |
LuanExcel
/ EXCEL CHALLENGE 52
Created
October 28, 2022 08:43
Extrair o primeiro dígito numédio e o último dígito de número que aparece na sequência. No caso de um único número (como a linha 7), apenas o primeiro número é este número e o último número estará em branco.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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
/ PQ02 - Mesclar com Inner Join
Created
October 28, 2022 08:26
Uso do JoinKind.Inner para fazer a Mesclagem e ja excluindo aquilo que for null
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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 |