Suma de consultas de Power cada 3 últimos índices agrupados por

[Syndicate_Admin]

Hola, necesito ayuda, por favor.

Tengo una tabla con datos diferentes para cada mes (o semana) y necesito sumar para cada fila cada tres filas anteriores.

En resumen, necesita saber la suma de "Minuty" durante tres meses o semanas anteriores.

let
    Zdroj = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("nZq90h23DYbvRTULEARAsIztMq6SSeNxocQpMtFIM3Him0mVC8glOI2S+wqWPBqdBck936L4LI2keQwQP3wB7g8/vENAzPAuvfvdXz+8/8l+/f6///z587//ZL/rf3z8vf3ym+NvPn38++d//e8/9ttSEKQc/8Z+4N2P6c2gb88gZFKFCOgbZxFg0zqD8hqU965RBT3+HDvsBshb1FhJIiB/RlQE6wzCNQj3oMLcD7t02A2Qd021Zo6A/GHXkiV7UIHNGQ1OmTmoUrpn1Flv50wnVAUpwHEHRLVB1pmzPiC84jAcf86d9XbOdD4Fqa05f/j8698+/fH9Gy1SacCSKNcawjnDGhRiTFyFQzgXv0wguabMPefuHppPBlBLh5lTNmaV7aE1QVVJ0ktgEE+02aonli+ZJkCYGhAHYD6/uFkFpkIqa9gLPz/+48MHd2iZUwuxfCi1imCynw3u0k8Pq8UqKTWRGrLNxSCDZZiWJHlhGy1to6+w7+znt3/5+dMvH99301grpIw9nsO8E2tlGl14aricoLUWwrkEqSwKOQmjhHBzgmQmyYnWtMtz+/Z0blabiGqlzhhknU4t16bmJtWQmy4/7NRKgQSWdAHbfI0SUJXEwBqA+e6hxVRJkiobR1/CvkYA1a4n6x6tbHLjpZdPLOsbNWPStqgCXrJ4a1dtjS01oCuLcWgn1iqY/G574zXRfFxRra5xl6a5pEVLWkqNmQIsZ5hlPlZrQkpR2NOZ5aMEMFHvtpdn9vvPv/70549zAE4a2u47Sjq0y22aV5uVyAKAWCJ+OtM4C5SWiMpLR7fxfL7uUOyiSgJdcESS49SFqFoMBLt0vH1sc68lhpCTM0k3oEv3/EVnGsi0BnLIO3dWJFRKyqS7qnzhoksL5aIEqSEvMlbWxsmWZsOxlWZq9UjYkWc3YC79c6sokmopNULzCSt2yZngK7Cg1TWtXtgGFUsi7i2oj+ftDs4ZV8QMM08xh2hzFAAhaa8mT9M1TS9cZRN9CXIXVvlh4Q2e95WaNkvgQbqPm5zlUqx3kOiK19a8tuflVqqmMUiN/+Q7uG8m89TUfKVcYrzFpNFFZADlOwmX1hJzXdB61ixoXxZRm2aZjkbzxdM7LJ8jhe2CN00EUaAPAzJY1gkLBoE+TZD0EKe1D8oTMG+A+w2M1YOaEG95uEyDegc4x6PfghHUVGN6jPGF+pQQAU5VIdRM2ZBsnf1ywb7FPkHrxi2BBnE++2qFrKlk1BDON1DIxYa/xKO7e9x52fMVeLHUQhUx+/r4kR8u3+H5aORiai4pBXGrWZeDLF8VdnLW72yq3wLnUOw9ZbB7x/Q5javxNm6W+4T8ZYl3H+dlcLNh3AYuprLClSVuv6yxjgI1p1qHs49kOeFWwdgvk4gUbOzCvlCM8KY8btZEE8IIbgA4S5VaDdhq2QEvD9AvIMxVsrantLXvEjdvqJqWQ0gtraMl7mp1Q1ghcWs9HHUw347zziqrybyjle5wq2DsNy6ZCMQmFWxb4KV9vtYEi2kCE48atM93ebYKTa2pbM/vBdBnH7Pp+NQeM4EHbia9fDl+oiR9SIyH23d4PiLVxoJjGz8MDAD9TNUy2bT3kN4r3hzh/bqDWJXw2C1zCDc9sYlNVcma1ta6F976+Eq/Ji2pY/b5+jXrxOq34IomS9p+8iYAG6zSeDTo2/msZ9rK2f24TJrFxuVWhxxdAS/N886yqAWjQn8Yvo+bOrPYcGD6cQjSgLtzqckxllLY2addJ1nnOza6uvX1hXGLexIoZc1bb18e3vPG2dS8iaoi21S5pPnlFiqYFqUcC6zfrB9RgJQ5Gtd57kM51pQtr4Cb1Uq+2q3wsarJVMZKYlDvAF1lWLsrzURaebSK+8DFHE4Vd7A5Gk+oqxe6iGnToNHgWGhrCVl3+aQTw+0ede7TLh/W7uMu38Ji1u2eEGPG7Z6wJtpmo5f3K71M7XjpN+HTxdaYrM/A2bz9ApNNKTMnGHfPEvfCPi8EqlBmq9nepe7b5xLPasIqzWSUBs2b9npc9ItQvm/dlMgWW0iWzBjCuZYiTUymAPdlcsy455sW8vHczBKjTXmsWk0DIIfDelZkoJCwyDJL2hLXtq4eAqqlAqN3PmLxdpp3FZlzfw4J0eYcKdZPFEYcVrhVCl+spg2Vzdk2QhEA+pJVYDYdQHuHXwB9jxJmseEs99nn/gn6sqiZNAH25/FYdJ87nkUjQ7I2vz2+S5zP5MJggrYRx3z1/a5AhUPj5QUNN6t4vNjt213Lx3a6/y8f8T3xJuueaS4SCqg1QRmZd5s2VUZjG7mhBo3zkZDjZSTheLSJWfcsA/T4wKNZ8oVo/kuKqqbfU6WYbV6OWXnJ8ZS8PbgXWbJ5Domgpu4kNnyC1BbLkblaLUlSqYRB+6YnzD70aGVZAZfvF+ieQ06XLNacdLyI9o+Esdyg+foiUzt2ZQ9td5vmz44ail2LPNIkhDulsPX1Q1DojraKxP5hKreWrfxRcWveC6BLPQY0ZWz9eIiKAHD+kKHQ0e9y6Px8f2rFVFTi0ldk93GLT2FJEhHFrTstF0wY50S8pG0ep/Dyoav0Knw4ewflW4r1TqvYhuPfBIBTXLHa0FNL375HgD6VrSHXw8T+heMSOMfi4q3r+OIlJ8lDz97G+a/brAMQJHrsAkK450w5Ngum7oa4u02bugqVQimPHhU6uedL2xRXTQS0zZSXtp2+pSxMdHyOE8P5jZG0YxuI56z78f8=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [id_obdobi = _t, RADA = _t, Období = _t, Poradi_obdobi = _t, rok = _t, hala = _t, druh_vyroby = _t, Minuty = _t, Index = _t, Index_predchozi_obdobi = _t]),
    #"Změněný typ" = Table.TransformColumnTypes(Zdroj,{{"id_obdobi", Int64.Type}, {"RADA", type text}, {"Období", type text}, {"Poradi_obdobi", Int64.Type}, {"rok", Int64.Type}, {"hala", type text}, {"druh_vyroby", type text}, {"Minuty", type number}, {"Index", Int64.Type}, {"Index_predchozi_obdobi", Int64.Type}})
in
    #"Změněný typ"

Gracias por su ayuda.

[Syndicate_Admin]

¡Uau! ¡Qué solución tan simple! ¡Perfecto! ¡Gracias, me salvaste la vida! 🙂

[Syndicate_Admin]

let
    Zdroj = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("jZq/jidJDcffZeMKbJftcoV3RwgRiOR0wcIRIFa7Ege8DBEPwCMcycJ78e2RTr9qd/e4gtHOBh/Z5f92z/fffxASYfrQPvz2L58+/oh/f/Pff/709d9/xG/fHP/78vlvX//1v//g196FvH/4ob0LfXeGxDSCKujbJIlkxnhBvKWeDgqpoCxpWqhXUH6TdpdFPdmCutlqiHsoqxcx2CooG2J0dv4F6rRlPQnvL/WeoMubhotWUHqTjkkcL2jLEICMegVd3tRF5xn6/def//rlDx/fkxU+ybwpj1GzSeSkribNhlvNJmuykvNobCzVQ7MfKOCJF9T3HjpdIry5yBmtI2w6qbRJahWZ/WgT0dm6xoa6n//+6VN6KFubNZgNG8NdGn5mpW4mR0fgtek+aqnJSEzwZPTmvEjVW6m/ws+v//zTl398/vgm1GJQY1mtq5tPPVhuNOes2eSbYR7EzU28Zq++YVPnptVbvzu9FXErEoh5kx3w9FIeM6Ctjlrbby4v7Z0awbmV1By/Sjq8GVlUZM6Z6Gg1zYePHfJlIgkUP+TM7L6j7AIiWwZLi7nEke1IHHMavEJrF7HN4jk9+CiAc1RCUyQIIkHbNNMKTCIROzKQZ6Fb5PJOPoJImq514fzO3339+cc/fb7xpqJ0aotTU3pAc08fqrCQSC/VTUKNnfpsqv1R3+cWIY4y2JzW5vLsl1Oi6YCRXNam/fDUa1VQo1rXKxZUaZlrJjoZ+opYrWR6n7r23lgjR+xGIQnrodSm2BIGvhVBmKURtm0OLckUQDyHuLfR+yjRHAWOeonu22lBx6ZUGtKb2pplD2iS2h0Soa9wSV6NREIt1tCLTXUN7bcRr43wAc3q6oyJgGAuyYu6hiWpufqi79xDefYR7TT7PZDfXoQGppuh3Ev0ZqJaO/YDlRPG+pzN7BVCb1vdlji8sKSyO7qhuqOJUY1m04gRXOnmUqLZH6JxNPqxzNVv2+GGfZgDg8nkVeEH9GqhpV4+QZeoi2OM77pMQk/oJXZcJ3qRelL1l3r7JNMF1WA2ihLM3hwD21/rLFGAOaGJO0bMZksVYdkzEJZbh8xlgHois324o2+20BK8m4etpHLk4IVISEzvCa2MY4RyhXFEl0J5D17nGBU776v3YJ4KJsZvzHmmr6rDfUMisoOwoYyxqtr3zKNBmPNAlOQlAibSuQmthn1Ar41kDKDYW4uH5lUBiirSMtQK8LrDTeyNaF2LRN0CVbA42pxSgFnVsECzPJL6DNaWZWxEjvFJ5ihk5shz6ajr6LVRysw1xBCjbc5wKdHsTTNMI9gylimGt4dZ8RanhrC3LPDAEHPcWTaE5oFtsmJIXAcKtjvrXu4sWE/kuD1YAV6Oh45pDTtGRKlrtq2/FUuEQyUzxy0kOuK2L+70nVJChFmtrWcd3puDNdgxB8+xtuhbkVlV84B5BqkX4KUaOEYYdNq1ST8oew08PyZS3VB12acVmXks/+GlwJtqSdo4eGw8cj04YBJBA+s+Cy4vbxKE/qxcGTVfRg67UGOrbXqdDMWPdXgu08TuTmLHOsPao0RT9CAdsb+P0dlK9GZ21iFnrLTr9ZD4JO4y+Ew6jhTRC4kbV65n8P0j1z23cQa8Bzcuec8S379YPgt8/xrHe2sl6zzO7Wg9ekbLsRATgVmjU7Xa3J+HKxtidc2tW5nJkYgbxB1aVpQiL3ul9UgDwa3ESwjArtQQBlKAKT18YvtpZMuJ4FngWlmxihA4r7hLBEQM1HGxDZOe+xwFNelrUs0NRY9mNVunNYtvuayomPHbnWhD3tkTHbkRtFpm86gAiKHqXI2zdwDhIDPUcs3qbmSWmzmGOl7nq9uX5tAZrNFIlmP1s2XXjIR9mBqKiBVgjoFuhHY+1SpNcz52GnT0yFejk83rCWqrHXeFeSYr2wQJdi3qiyfvuUv0TMOYTKMUmG3jx42oyXqSepa4lvI4vlVMOLPg8neDEZg92tBKXm5yCDY/br6z9MW7h6En6JJTjpGTfMzKE9cohStaxz5ZyrzcMd8Gqxj2ajnyeBg6FVUZ3GI9gN5zOdoU/QbFeOmN91x+o05xFEdbnfEInpyPqnGU/zhzG9VmTkaAS8gs0eRKI8EEgBqwtIAn9Hq473rkIxfvzFk1OzoWtrJlnXv2ZPrcro4VUncknsZ5DADcdC1V2+e2TiWU0wNZjEidsvz9wxN6sakMDFajL1ePJzQHAYrAOMSSntGdLRkTsvPSze/B/NkQMa7UdJ3Jn8HVH8csj+64NMd77pIh2rEk85pZjy9cyzE62miYy2VD3ukDcDfV44tNBeb9yOexd77drn74Pw==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [id_obdobi = _t, RADA = _t, Období = _t, hala = _t, druh_vyroby = _t, Minuty = _t]),
    #"Změněný typ" = Table.TransformColumnTypes(Zdroj,{{"id_obdobi", Int64.Type}, {"RADA", type text}, {"Období", type text},  {"hala", type text}, {"druh_vyroby", type text}, {"Minuty", type number}},"de"),
    #"Added Custom" = Table.AddColumn(#"Změněný typ", "Last three", each List.Sum(Table.FirstN(Table.Sort(Table.SelectRows(#"Změněný typ",(k)=>k[RADA]=[RADA] and k[Období]=[Období] and k[hala]=[hala] and k[druh_vyroby]=[druh_vyroby] and k[id_obdobi]<=[id_obdobi]),{{"id_obdobi", Order.Descending}}) ,3)[Minuty]))
in
    #"Added Custom"