wonderful series of powerpivot videos

Thanks for this! I got it working, but sometimes the output shows less rows than my samplesize. How do I fix this?

👌🏼💪🏻💪🏻💪🏻

Truly a fantastic tutorial, thanks for the contribution. 👍

very well done

This presentation has really helped me in my power bi project

you are a wonderful teacher and with a knack of simplifying complex opics. learnt so much from this series. hope u will update this series with more videos covering many more dax functions. Do you have a similar video series on Power BI

Great

Learning about Excel and pivot tables has non end ! Thanks to you !

Excellent, clear explanations. Many thanks.

Excellent 🌹🌹

Awesome Video, I got something new.. Keep creating more videos... ❤

Great Video, I learnt new thing, Thanks for creating such wonderful video.

Great video, masterful explanation. Greetings and thanks

Great example of Table.Buffer, something I've never exploited but after this video I really need to apply it more often in my solutions. Thank you for sharing and explaining it in a simple way!

Awesome video!.. Thank you for shaning...

i have noticed in the measure calculating gm is being divided by 1000000... any specific reason.. thanks for your clariification

Outstanding! Thank you.

Thanks as always. A quick one. What should we do if the refresh time in the PQ Editor is taking too long? This is happening to me right now and I have so many qurries in one sheet

If qty equal to monthly qty it is correct

tks

EXCELENTE curso! Gracias"

🙏🙏🙏

Excel-lent. Thank you very much for sharing this.

So glad I found your channel - been struggling with this issue for a while and this is beautiful solution

you are absolutely the best...

Hello, thanks for the video. Could you please add the link to the video where you apply formulas (Act vs Budget) to calculate variance? Thank you

Thanks a lot for the wonderful tutorial. One question, my FY begins and falls in the middle of the month, viz., mid July to mid-July. Occasionally the date varies such as 15 or 16 July and ends 365 days after. Any solution for this situation?

This is an interesting video, thank you ! I think you should have explained also the disadvantages of using Table.Buffer function, people must know it is not universally advantageous. Table.Buffer uses a certain amount of memory (not entire memory), if that amount is not sufficient (for very large amount of data, i.e. tens of thousands of rows + tens of columns at least), then data on top of allocated memory will be written on hard drive, which could make the reading/refreshing VERY slow, so the apparent advantages are gone. I guess that very fast hard disks (such as SSD) could not have this issue, but it shall be trialled. Thank you !

Great as always. Thanks

Great again, keep bringing these techniques to ease in understand pivot tables better.

Great topic, thank you 😊. I wonder, for the inner table your can’t use “_” as the variable instead of “it” because the Table.AddColumn “each” is like an implicit “each _” so that variable is already taken up for the outer table, correct? So at 16:47 the outer tables “[Total Quantity]” could also be called “_[Total Quantity]” with no difference, correct? Thank you 🙏🏽.

Loved it

Thank you sir Realistic and informative example which will help us real life work. Thank you again

Thank you for showing the trick of using each with records to extract multiple values 🙏. At 18:03, Table.Sorts comparison requirement as a list is surprising given it says “as any”; it would be much appreciated if a video was made going over how to know when a function parameter requires a list or record, even when it doesn’t say. Or maybe it just needs to be memorized? Thank you.

Final I've been here

I'm in Progress. :D love it

It's exact what all of us want in PQ. I'm here, My man

I've been here and let you know. I'm still confused about how and when to use table, list and record in power query

I actualy love your tutos ! Thanks a lot !

Happy sir now regular videos. Very useful thanks

Thanks for sharing such a nice series of Videos in a simple way, it would be helpful for person like me who do not have resources to purchase entire course. Thanks!

super sir

Thank you very much, Sir!

Very useful. Thank you

Brilliant work, I was spending full day today thinking for the same solution. Thanks for your support

So, if we notice there is some delay in our query, we use Table.Buffer then . Thanks

Thank you for the information! I will include the Table Buffer in my report - your assistance has been instrumental in enhancing my efficiency and productivity!

super video, Thanks

your effort is highly welcomed. Next Level of performance boost would be the reduction of redundant calculations. I edited your Query on the last 2 steps and so you can stay below 1 second refreshtime. let Source = Excel.CurrentWorkbook(){[Name="Data"]}[Content], #"Changed Type" = Table.TransformColumnTypes(Source,{{"Date", type date}, {"Amount", Int64.Type}}), #"Added Index" = Table.AddIndexColumn(#"Changed Type", "Index", 1, 1, Int64.Type), TableBuffer = Table.Buffer( #"Added Index")[Amount], RT_Values = List.Accumulate(List.Skip( TableBuffer, 1 ) & {0}, [RunningTotal = {}, CurrentValue = TableBuffer{0}], (state, current) => [CurrentValue = List.Sum( {state[CurrentValue] , current } ), RunningTotal = state[RunningTotal] & { state[CurrentValue] }] )[RunningTotal], ReturnTable = Table.FromColumns(Table.ToColumns(#"Added Index") & { Value.ReplaceType(RT_Values, type {Int64.Type})}, Table.ColumnNames(#"Added Index") & {"Running Total"}) in ReturnTable