Back in September I delivered a session to the Vancouver Power BI and Modern Excel User Group. The topic was CUBE functions in Excel and if you missed the session here’s a link to the recording.
A question was posted into the YouTube comments of that video asking about the difference between children and members in the CUBESET function and although I provided a brief answer as a reply in the comments, I think a video would help put some meat on the bones, so to speak, and that’s what this video aims to do.
For the video to make sense you’ll need to have an understanding of the Data Model in Excel and what CUBE functions are used for. I’m not going to cover that in this video. I’m going to go straight into answering the question.
Download a copy of the file(s) used in this video: https://share.zight.com/7KuNOoLY
Thomas, this is awesome! Well Done!
Glad you found it useful Philip