brilliant stuff, practical, not too basic but advanced enough that I wouldn't have needed to be here otherwise. I'll be using it tomorrow, being decadent, too much wine right now.
A quick tip here, i used Table.Buffer before the running total calculation step, it reduced the running time of the query signficantly, please try it and let me know
brilliant stuff, practical, not too basic but advanced enough that I wouldn't have needed to be here otherwise. I'll be using it tomorrow, being decadent, too much wine right now.
happy that you liked it
Thank you very much for your efforts
My pleasure 😊
Absolutely brilliant.
Thank you Antony 🙏
Great. Thanks a lot!!!
Most welcome
Great. Thanks a lot.
Most welcome!
Excellent
Thank you 🙏
The information in this video is too much, I need to view several times to catch all the points. Thank you very much. Thumbs up!
My pleasure, best of luck dear 👍
Thank you for your efforts awesome
My pleasure 🙏
Excellent... Genius ... However if the data is over than 1000 , is it running slow or not Sir?
Thank you, actually it is a fair question, i tested with 5k lines, it took around 10 minutes to refresh, so for 1000 line it will take maybe 2 minutes
A quick tip here, i used Table.Buffer before the running total calculation step, it reduced the running time of the query signficantly, please try it and let me know
Can I calculate the running total by a measure, so when I filter the date in the pivot table, the running total will be dynamic?
Absolutely right , 👍
Can we have the rest of the Solutions as well to learn from Please?
Hi Qasim, actually the video is summarizing all solutions I received