Where is the original data, to visualize what u r doing? Good explanation but I cannot follow u without seeing the original data to understand when u slice by year or month ...
If I convert a pivot to cube, and then later refresh my power Query, will it automatically update the cube table like a pivot table would auto update with the new date field/column, etc?
Thank you very much, great Job! One Thing keeps bothering me: how do you rename the "title" of the Connection from "ThisWorkbookDataModel" to "cube" (as in your Video)? Thanks again.
Great video but this seems like a lot of manual work. Power Pivot will pull new through data automatically where as in the cube you have to update your data by hand if you want to make additions and modifications. I guess this is great if you have a "set and forget" style dashboard however i still think powerpivot has some great out of the box functionality that exceeds cube functions
I agree, but my customers want the ability to insert columns to their pivot tables at different points in the pivot table (which you obviously can’t do). So converting to cube is helpful for that. My problem is what you mentioned.. when I get new data I’m for the next month and hit refresh all for power Query, I want it to auto populate the new data like a pivot table would. To my knowledge the cube won’t auto update unless you go add in the formulas for the new data. (which might have a new date in the column field list).
This was legit the most simple and useful video on all the Cube functions. Thank you very much.
It is!
Very helpful and useful demo, Jae - one of the best I've seen thus far. I'll check out your other videos! Thank you!
Where is the original data, to visualize what u r doing? Good explanation but I cannot follow u without seeing the original data to understand when u slice by year or month ...
this is GOLD ❤
Thanks for sharing! 👍
Excellent topic, nicely sliced , good job mate keep it up. Very useful.
If I convert a pivot to cube, and then later refresh my power Query, will it automatically update the cube table like a pivot table would auto update with the new date field/column, etc?
This is extremely useful, thank you so much for sharing!
If my next month of data has a new sales person, will it automatically add them to the cube upon data>refresh.
Thank you very much, great Job! One Thing keeps bothering me: how do you rename the "title" of the Connection from "ThisWorkbookDataModel" to "cube" (as in your Video)? Thanks again.
thank you so much...
Thank you
Great video but this seems like a lot of manual work. Power Pivot will pull new through data automatically where as in the cube you have to update your data by hand if you want to make additions and modifications. I guess this is great if you have a "set and forget" style dashboard however i still think powerpivot has some great out of the box functionality that exceeds cube functions
I agree, but my customers want the ability to insert columns to their pivot tables at different points in the pivot table (which you obviously can’t do). So converting to cube is helpful for that.
My problem is what you mentioned.. when I get new data I’m for the next month and hit refresh all for power Query, I want it to auto populate the new data like a pivot table would. To my knowledge the cube won’t auto update unless you go add in the formulas for the new data. (which might have a new date in the column field list).
Can you use cube formulas to look up items instead of values?
Jonathan yes. The cubemember function returns members of a dimension. You just have to know the dimension key (item number or gl number etc.)
Jae Wilson thanks I'll give it a go 🤔
You did a good job but it could have been made better had you explained the syntax . eg, referring to a cell, use of ampersand etc
(sales - cos)/sales = margin (sales - cos)/cos = markup 2 different things
Where can we download the file u are using in the video? without it, the video is useless. You waste our time and yours