Thank you! You are fab to follow along and explain everything very well.
@ExcelExciting5 жыл бұрын
Welcome & Thanks for your feedback.
@mohamadmneimneh4036 Жыл бұрын
I've been searching for this solution for the past 2 days... awesome solution!
@enocharthur4322 Жыл бұрын
Best solution ever. Thanks so much. Please do more tutorials
@ExcelExciting Жыл бұрын
thanks for the kind words and motivation.. more to come :)
@andrewrender7 ай бұрын
SUPERB! Lots of videos on this subject, this is the only on that appears to work without errors
@tablefancy79922 жыл бұрын
Exactly what I needed. Thank you for the video sir.
@ExcelExciting Жыл бұрын
Glad it helped
@Inayathalam_VinothKannan2 жыл бұрын
I was struggling to get this and referred to many videos, but this is top-notch. your work is highly accreditable
@ExcelExciting2 жыл бұрын
Thanks a lot for you feedback, Glad to hear you find the video help & do recommend to friends as well :)
@JohanBredell Жыл бұрын
I'm not going to make any negative comments toward others but I just find it absolutely fascinating how someone has the ability to simplify things to a level that stupid people like myself can understand it. Brilliant, brilliant. Thank you Faraz!
@ulisesgabrielignotflores62912 жыл бұрын
Been watching tons of videos, but this one was the easiest one. Thank you!!!
@ExcelExciting Жыл бұрын
You're welcome!
@ziga328 Жыл бұрын
This is so much simpler than other videos I’ve seen on the topic, great solution and explanation!
@FalconFlyer75 Жыл бұрын
Edit nvm I just concated the year to the product and then followed your steps, worked perfectly, I can’t thank you enough Phenomenal review, I've been struggling with this for like 3 days now and you video worked (almost perfect) i'm stuck because it's doing a running total across all years but I need it to reset each year, any advice on how I can do that?
@ExcelExciting Жыл бұрын
Great to hear it was helpful :)
@janoskidgreat9622 жыл бұрын
Boom! This is the one that I really need. Much easier to understand.. thanks bro! Keep it up!
@ExcelExciting2 жыл бұрын
Welcome buddy.!! What was your dataset about
@TheWeteyezz Жыл бұрын
Great Video! Only problem is my table kept unsorting when I did group by so I needed to add a buffer: = Table.Buffer(Table.Sort(Source,{{"date", Order.Ascending}}))
@user-yg8gu3io3z Жыл бұрын
Thanks for the great video! its clear and works like charm! I do have one question as to how to include the resulted RTBP column in BI. the issue is that when I add this column as a value in a visualization, the value is automatically aggregated, though the column is specified as "Don't summarize" in the data
@nicoloconnor78392 жыл бұрын
Thank you for this tutorial! I'd been searching for way too long. I was able to do this in both Excel and Power BI.
@ExcelExciting2 жыл бұрын
Yeah !!! 🦸🏻♀️ superb.. glad to hear you find it helpful
@reginaldbal Жыл бұрын
Just fabulous Faraz!
@ExcelExciting Жыл бұрын
Super 😎
@OzduSoleilDATA5 жыл бұрын
VERY VERY nice! I was asked about this a lot and didn't have an answer. It's nice to have a solution for this!
@ExcelExciting5 жыл бұрын
Thanks Guru-Ji.. :)
@OzduSoleilDATA5 жыл бұрын
@@ExcelExciting someone just asked me how to do this. I'm about to send them to this video.
@ExcelExciting5 жыл бұрын
Thank You Oz Ji :)
@deivisgarate26823 жыл бұрын
Great Video Faraz!, I was searching for a long time for this and every explanation I found was very cumbersome until I found yours!, I really like it and it was very easy to follow!. thank you
@ExcelExciting3 жыл бұрын
My pleasure.. 😇 Glad to hear you find it helpful
@NickRaven783 жыл бұрын
Thank you. This exercise helped me finish one of my file. Great work.
@ExcelExciting3 жыл бұрын
Awesome 👏🏻 glad to hear it helped you
@NickRaven783 жыл бұрын
@@ExcelExciting Could you please help me with one more thing. I need to calculate a running 12 months Total and Average by Product. So let's say I have the sales by Month and by Product for the last five years I would need for each month and each product to get how much we sold in the last 12 months and what is the average for the last 12 months. Is this something you have in one of your videos? Thank you in advance.
@BenNyBaklava2 жыл бұрын
What a legend
@ExcelExciting2 жыл бұрын
Thank You 😇
@Everyonelovesyou3 жыл бұрын
Thanks Faraz, it helped me a lot in pressure situation
@ExcelExciting3 жыл бұрын
Glad to hear that it was helpful 😀.. What are your daily challenges with power query ? feel free to check our website forums section excelexciting.com/forums/
@Everyonelovesyou3 жыл бұрын
@@ExcelExciting Thank you so much Faraz, my challenges are customer wise analysis. Contribution analysis, Split a grand number into group and sub groups. active customers by group by sub group etc
@aartiladdha014 жыл бұрын
Thanks for the great working explanation. Best one I came across the net. Keep doing the good work. Thanks a ton! :)
@ExcelExciting4 жыл бұрын
Thanks a lot 👍🏻. Glad to hear you like it 😃
@akashdshetty45182 жыл бұрын
Hi, Thank you, I have achieved running total with this step. But when I merge this running total table with another table, the new table is showing different results its changing it's values. Can you please let me know how to solve this issue.
@MKHAMMER003 жыл бұрын
Amazing Thanks
@ExcelExciting3 жыл бұрын
Welcome 🙏🏻
@arvindsinha73238 ай бұрын
big thank you
@ExcelExciting5 күн бұрын
You are welcome
@MrShabbir19734 жыл бұрын
Dear Faraz very well done it is very informative and I really like your way of teaching.
@ExcelExciting4 жыл бұрын
Thanks for liking 😃
@silverfunnel68193 жыл бұрын
Please continue your good work! 5/5
@ExcelExciting3 жыл бұрын
thank you..!! glad to hear you like it !!
@ankithful5 жыл бұрын
made my task simple, amazing video...
@ExcelExciting5 жыл бұрын
Thanks Ankith 💫
@janandksenia56344 жыл бұрын
Great explanation, thanks a lot!
@ExcelExciting4 жыл бұрын
Thanks 😃, glad to hear you like
@safashaikh40895 жыл бұрын
Very helpful video Faraz best of luck
@ExcelExciting5 жыл бұрын
Thank dear
@MitanshBansal Жыл бұрын
Thank you so much... ❤️❤️❤️
@ExcelExciting Жыл бұрын
You're welcome 😊
@borischivapallottole5 жыл бұрын
Thanks for this awesome video! it helped me A LOT!!!
@ExcelExciting5 жыл бұрын
Welcome dear & glad to hear that it was helpful =)
@borischivapallottole4 жыл бұрын
How could I achieve the same result (return in each row the total sum of a column) but based on another column value? for example, if I want to return on each row the total sum of the column sales, but by country? thank you so much!
@ExcelExciting4 жыл бұрын
Do you mean you wish to do the running total by countries & then another column show you the repeating total of the country along with running total.. is that correct ?
@borischivapallottole4 жыл бұрын
@@ExcelExciting No, that came out wrong :) what I've meant is: let's say that I have a table of 3 columns: country, customer, and sales. what I want to achieve is a calculated column that returns on each row the total sum of the column sales, by country. Let's say for example that I have 3 customers within the country Brazil (customer A, which sold 30, customer B, which sold 40, and customer C, which sold 10). then I have 2 customers within the country Argentina (customer D, which sold 30 and customer E, which sold 15). the calculated column I want should return on each of the 3 rows of brazilian customer A, B and C, 80 (sum of 30+40+10), and on the 2 rows of argentinian customer, 45 (which is the sum of 30+15). How could I achieve that using M? I guess using List.Sum function. but how do I get the total grouped by country? Thanks in advance
@williamarthur4801 Жыл бұрын
If you're data does not always have the same header names, you can declare them as variables, ( T as table , myColumn as text ) => , and then use; Table.Column; List.Sum ( List.FirstN ( Table.Column(T, mycolumn) , [Index] ) )). i cannot take credit for finding this out.
@Gabricardo04 жыл бұрын
!!!!!!!THANK YOU!!!!!!!
@ExcelExciting4 жыл бұрын
Welcome 👍🏻
@entertainmentgalaxy9715 жыл бұрын
amazing.. thanks for sharing PQ fun...
@ExcelExciting4 жыл бұрын
Glad to hear you like it.. welcome Haider
@nimishamodi61692 жыл бұрын
I have followed your steps, thoroughly but at the end my running total has error? would you know why?
@ExcelExciting2 жыл бұрын
What is error you are getting ?
@treelo114 жыл бұрын
BLESS YOU
@ExcelExciting4 жыл бұрын
Thank You!
@bramdb24734 жыл бұрын
Hello, is it possible that this solution is heavily impacting the speed of the refresh?
@saikrishna53944 жыл бұрын
Hi Fraraz, I couldn't find Invoke Custom Function in my Add Column(General) ribbon. Any help soon?
@kalaiselvan32394 жыл бұрын
Sir, what to do instead of sum if the data to be substracted and percentage difference between previous value with the
@kalaiselvan32394 жыл бұрын
Sir, in the same way is it possible to find the difference instead of sum.. i tried but getting only errors..plz help me on this if possible
@ExcelExciting4 жыл бұрын
Hi Can you please share the sample file with your desired results manually entered.. feel free to post your query on our website forums section excelexciting.com/forums/
@Everyonelovesyou4 жыл бұрын
Thanks, very helpful
@ExcelExciting4 жыл бұрын
Glad to hear you find it helpful 😃
@Everyonelovesyou4 жыл бұрын
@@ExcelExciting I was gone crazy to find out this ..your video rescude
@anyhizzle3 жыл бұрын
Hi, this is great! However, I’m still trying to figure out how to do this on an additional group. For example, DATE, PRODUCT, and LOCATION. Any help, please?
@ExcelExciting3 жыл бұрын
This could be possible by doing the same technique, where the grouping of each columns should be done correctly then apply the sum formula
@TheWeteyezz Жыл бұрын
@@ExcelExciting would it be possible to give an example? I've been stumped with this for 3 weeks :(
@ExcelExciting Жыл бұрын
do you have sample data you can share where you are facing the issue.. I might have a look at it !!