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, 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.
¡Uau! ¡Qué solución tan simple! ¡Perfecto! ¡Gracias, me salvaste la vida! 🙂
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"
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 |
---|---|
2 | |
1 | |
1 | |
1 | |
1 |
User | Count |
---|---|
2 | |
2 | |
2 | |
2 | |
1 |