I swear I have been looking for this answer for MONTHS, trying to work it out on my own, and you bust it out is less than a minute. Absolutely brilliant--thank you!
How could you do this if your group by column had three versions of the same group e.g. A1, A2, A3, B1, B2, B3 etc and you still needed to sum by all of the As, Bs etc. I have this problem with metrics descriptions in an excel report I need to lose into power bi. Changing the excel template isn't an option. Would prefer to do it in pq rather than DAX for modelling reasons.
Thanks @CurbalEN and @naylord5 - I did a hybrid of both your suggestions and it worked. The example I gave was over simplified, the actual metric's descriptions were quite long and ended with (C1), (C2) and (C3) but only for one of the contributing organisations. Each metric had a numerator row and a denominator row so by removing the last bits in brackets I could then do the group by bit and sum all numerators and denominators which I will eventually need to calculate percentages for. The other organisations do it differently. Let this be a lessons to all - don't allow managers who won't have to do analysis to design templates for reports 😁 BTW - perfect timing for me, Ruth! Keep 'em coming.
I swear I have been looking for this answer for MONTHS, trying to work it out on my own, and you bust it out is less than a minute. Absolutely brilliant--thank you!
Hello from Brazil! I've been looking for this all day long! Thank you so much!
i randomly get a recomendation of this today. Funny thing i was wondering how to do exact same thing tomorrow. UA-cam reads my mind
Thank you so much! It was so much pain to merge table with previous step to get back the info
Thank you so much you solved my 2 year pending project
So simple, yet so helpful. Thank you for sharing. 👏
Nice one! Thank you
Thx for ur Videos!!
Good one
Bienvenida muy guapa❤
How could you do this if your group by column had three versions of the same group e.g. A1, A2, A3, B1, B2, B3 etc and you still needed to sum by all of the As, Bs etc. I have this problem with metrics descriptions in an excel report I need to lose into power bi. Changing the excel template isn't an option. Would prefer to do it in pq rather than DAX for modelling reasons.
Can you create a main group for each category in a new column and use that?
You could get the first char of the column (in your case A, B, etc.) an then based grouping with that new column that contains only the letter.
Thanks @CurbalEN and @naylord5 - I did a hybrid of both your suggestions and it worked. The example I gave was over simplified, the actual metric's descriptions were quite long and ended with (C1), (C2) and (C3) but only for one of the contributing organisations. Each metric had a numerator row and a denominator row so by removing the last bits in brackets I could then do the group by bit and sum all numerators and denominators which I will eventually need to calculate percentages for. The other organisations do it differently. Let this be a lessons to all - don't allow managers who won't have to do analysis to design templates for reports 😁 BTW - perfect timing for me, Ruth! Keep 'em coming.
@MpT_Head Well done!
Hidden wonder - Allrows ...
It should be a short :D
for sure!
Great tips! just a feedback, please remove your video end cards. It's very annoying that it keeps popping up when the video hasn't finished yet.