Excel CUBE Functions can do everything a PivotTable does and more! - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 10
Simple
hi ma'am... i'm working as inventory controller in a auto spare parts company...i am using excel as my monitoring especially in ordering and receiving... currently, i am using filter to identify which car has an order for a particular part...now, want to change this process...what if i want to know which car in same model i am going to serve the part especially if the has only few parts remaining or only that car order that part...
ex... Part Number YYYY
car 1 oder
PN YYYY
PN NNNN
car 2 order
PN YYYY
in filtering scenario, if i'm going to filter YYYY, both cars will appear but i can't see which one has only 1 part order that for me, i should serve the part first in order to release the car from workshop...
thank you and hopefully you can help me on my problem...
reply
hi ma'am... i'm working as inventory controller in a auto spare parts company...i am using excel as my monitoring especially in ordering and receiving... currently, i am using filter to identify which car has an order for a particular part...now, want to change this process...what if i want to know which car in same model i am going to serve the part especially if the has only few parts remaining or only that car order that part...
ex... Part Number YYYY
car 1 oder
PN YYYY
PN NNNN
car 2 order
PN YYYY
in filtering scenario, if i'm going to filter YYYY, both cars will appear but i can't see which one has only 1 part order that for me, i should serve the part first in order to release the car from workshop...
thank you and hopefully you can help me on my problem...
reply
Alex
Thanks Mynda, however the use case is not clear to me from this video - where is the value? Now fully immersed in pivot tables and the calculations they bring, I don't want to go back to formulas - would this give faster creation of complicated formula we might have previously done in a calculated field or measure, but easier? And, in your example, I usually have ranges that extend into the future that update automatically when I paste new data with future dates in the 'data' tab for example - will we need to paste forward these formula then so that a date auto adds rather than it auto-updating as a pivot table would?
Thanks as always
reply
Thanks Mynda, however the use case is not clear to me from this video - where is the value? Now fully immersed in pivot tables and the calculations they bring, I don't want to go back to formulas - would this give faster creation of complicated formula we might have previously done in a calculated field or measure, but easier? And, in your example, I usually have ranges that extend into the future that update automatically when I paste new data with future dates in the 'data' tab for example - will we need to paste forward these formula then so that a date auto adds rather than it auto-updating as a pivot table would?
Thanks as always
reply
Tunde
Hi Mynda, thx for another great video.
As I have intermediate (bit of a stretch -) knowledge of excel, where I currently use tables and pivot tables for -getpivotdata- function to generate weekly and monthly reports. I have been a bit daunted and putting off a move from excel to a power bi dashboard/report, can the cube example you demonstrated be used as a replacement, as many videos say no pivot tables in power bi?
reply
Hi Mynda, thx for another great video.
As I have intermediate (bit of a stretch -) knowledge of excel, where I currently use tables and pivot tables for -getpivotdata- function to generate weekly and monthly reports. I have been a bit daunted and putting off a move from excel to a power bi dashboard/report, can the cube example you demonstrated be used as a replacement, as many videos say no pivot tables in power bi?
reply
martin
Hi Mynda, i wonder if i could bother with the following question?
Do u have a video/tutorial that explains the possibility of -importing- an Excel power pivot model into Power Bi, but with the possibility of updating my original Excel workbook and -push through- to Power Bi the periodic updates that i edit in the original Excel wirkbook?
Thanks
Martin ( South Africa)
reply
Hi Mynda, i wonder if i could bother with the following question?
Do u have a video/tutorial that explains the possibility of -importing- an Excel power pivot model into Power Bi, but with the possibility of updating my original Excel workbook and -push through- to Power Bi the periodic updates that i edit in the original Excel wirkbook?
Thanks
Martin ( South Africa)
reply
Eric
I think this is great when some of the values you want does not slice the same way as the others. This adds flexibility so that you don't need multiple pivot tables for this task. Although the head start takes a little longer, but I think it's great for certain scenario and allow for more options, thanks for sharing this, wasn't sure what is the use of these functions before!
reply
I think this is great when some of the values you want does not slice the same way as the others. This adds flexibility so that you don't need multiple pivot tables for this task. Although the head start takes a little longer, but I think it's great for certain scenario and allow for more options, thanks for sharing this, wasn't sure what is the use of these functions before!
reply
Nicolas
Excellent Mynda, now can get rid off my hidden underlying xtables (I was using the read table function). One question though. Do you know if it is possible to keep the double click drill down feature of the xtable with cubevalue ? Would be so cool to shift double click on the cell and get the underlying data...
reply
Excellent Mynda, now can get rid off my hidden underlying xtables (I was using the read table function). One question though. Do you know if it is possible to keep the double click drill down feature of the xtable with cubevalue ? Would be so cool to shift double click on the cell and get the underlying data...
reply
Cassio
Mynda, I love your videos, but I'm not sure about the advantages in relation to a pivot table. From what I've seen, they seem quite similar, the only difference is that in Pivot tables we cannot make changes as you showed in this video using the Cube function. Is there something else I cannot see clearly?
reply
Mynda, I love your videos, but I'm not sure about the advantages in relation to a pivot table. From what I've seen, they seem quite similar, the only difference is that in Pivot tables we cannot make changes as you showed in this video using the Cube function. Is there something else I cannot see clearly?
reply
Jerry
Thank you SO MUCH for this! I've watched at least a thousand Excel videos, and CUBE functions may have been mentioned once or twice in passing, never explained. I have never had the need to use them, but that's how Excel is - you don't even know you need them if you don't know about them! Great video.
reply
Thank you SO MUCH for this! I've watched at least a thousand Excel videos, and CUBE functions may have been mentioned once or twice in passing, never explained. I have never had the need to use them, but that's how Excel is - you don't even know you need them if you don't know about them! Great video.
reply
Benoit
I'm excited to try this out. While the syntax is more complicated, it may scale better than SUMIF and SUMIFS aggregate functions in terms of performance and memory. Not all my lists can be data tables, (e.g. data retrieved by a special Add-In), but for those that are, what an awesome technique.
reply
I'm excited to try this out. While the syntax is more complicated, it may scale better than SUMIF and SUMIFS aggregate functions in terms of performance and memory. Not all my lists can be data tables, (e.g. data retrieved by a special Add-In), but for those that are, what an awesome technique.
reply
seez
Nice I was always wondering how to use this feature. It might be useful to build some static reports, however I find the biggest drawback vs PowerPivot is that the data is no longer -in one piece- if you know what I mean. Still, for static reports, this may be very useful.
reply
Nice I was always wondering how to use this feature. It might be useful to build some static reports, however I find the biggest drawback vs PowerPivot is that the data is no longer -in one piece- if you know what I mean. Still, for static reports, this may be very useful.
reply
Add a review, comment
Other channel videos
