Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello, I have the following problem. My table looks like this:
I want to sum all the entries of the column "total secounds" with the same value in "Kalenderwoche copy". The different sum should be saved in a new table. Does someone know how to do this?
Thank you very much!
Solved! Go to Solution.
Hi @Anonymous ,
Do you mean something like this:
Mockup "Source":
Mockup Solution as new Table
Here is how I did it:
1) Right Click in the Query area > New Query > Blank Query:
2) write your table name into the bar
3) Select the Kalenderwoche - Copy column and choose Group By. Fill in the boxes accordingly:
Does this solve your issue? 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! | |
#proudtobeasuperuser | |
Hi @Anonymous ,
Do you mean something like this:
Mockup "Source":
Mockup Solution as new Table
Here is how I did it:
1) Right Click in the Query area > New Query > Blank Query:
2) write your table name into the bar
3) Select the Kalenderwoche - Copy column and choose Group By. Fill in the boxes accordingly:
Does this solve your issue? 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! | |
#proudtobeasuperuser | |
Thank you for your response. @tackytechtom My table is called "Abzug KW". Unfortunately, I get an error meassage when I type it in the bar: = Abzug KW
I think, the error is because of the space in the name of the table. Do you know how to fix that?
Hi @Anonymous ,
You should be able to use the syntax as #"Abzug KW" to refer to the table. Alternatively, you can right click on the table Abzug KW in the query pane and then press "Duplicate" as @mussaenda suggested 🙂
Please, let me know if this helps!
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! | |
#proudtobeasuperuser | |
Hi @Anonymous ,
Try using reference instead of starting from blank query.
Right click the table you want to refer.
Then you can follow the steps he showed you.
Hop this helps.
Thanks