If you find any mistakes here, it’s on me. ![]() With this I wanted to make it easier for you as a reader and I hope that I didn’t make any mistakes. Imke and Bill have sent me their solutions, but the comments of the source code are from my pen. The goal is to create a row at the end of the table that represents the total for the month columns and contains the row label ‚Total‘ in the first column. ![]() Happy learning □ You can download the sample file here. In addition, I already had a conversation with my friend and Power Query guru Imke Feldmann about another alternative solution, which I have also included in this article. He gave me his permission to share this solution with you here. Power Query guru Bill Szysz has commented this post (even though it was in German) and sent me another alternative solution via email. ![]() I wrote a German-language post about this here and used mainly functionalities of the UI. Recently, however, I was given the task of calculating sums over columns. Normally I calculate sums in Power Query over rows.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |