Excel PRO TIP: CUBE Functions | Udemy Instructor, Chris Dutton [Best-Seller Udemy Course]

[@shakingAami11]

Excellent work. I must say Chris is a serious master of his craft and on top, his teaching skills related to complicated concepts are exceptional. Thanks a lot for sharing.

[@Accelerate-Excel]

Cube functions should be much more popular, given how powerful they are

[@ngunghuong6938]

Thank you so much!

[@SyedMuzammilMahasanShahi]

Wow. Great. Learnt new thing today

[@ckcalvins]

In your example, what if you wanted to rank brands by multiple dimensions? Let's say you wanted to rank the top brands for the month of April by descending transactions? How would you manipulate the cubeset formula to be able to add multiple dimensions?

[@m.bouguerra]

salut ... grand merci pour cette vdéo très intéressante.. est-ce que vous pouvez mettre le fichier utilisé dans cette vdéo en téléchargement

[@rashadalexander3270]

Would you able to use if statements in conjunction with the cube functions?

[@AbhishekGuptaDoha]

Where can I find the video where you built the measures.

[@naimishsiddhpura2433]

I followed you and wrote Cubemember formula but instead of returning values like Planned, Actual, Committed; it returned values like 0, 02, 03 and 04. Can you advise why this formula didn't work for me?

[@future62]

Thanks for posting this. This will def help me on my way to building dashboards from Data Models. One question though- and I will try this later. But could you use the INDIRECT function to be able to avoid using the CUBEMEMBER functions in the row/column headers? The CUBEVALUE functions would be long, but then the tables would become dynamic and easier to manipulate in the future. I will give it a try and report back.

[@krishnamurthy7721]

Great fantastic keep it up and thanks

[@carlorf]

How can I display a CUBEVALUE including more than a single CUBEMEMBER? Let's say Transactions of Silver & Golden together?

[@stevennye5075]

Complex but useful

[@chavelooo33]

Excelent, Excelent & Excelent. Thanks for sharing

[@kozlo1]

Where can we download the file u are using in the video? without the video is useless

[@jaiconruedas]

This is really amazing..better than getpivot and all

[@telclissonperes]

Nice video! Could I use references with ?, * signs?

[@felipelandim2881]

Awesome.

[@stuartsaint4581]

Wish I'd known about this video when I first learnt about cube functions, had to learn the backwards way of pulling data from Power BI. One question: on the CUBERANKEDMEMBER I always use .children instead of .members, will this produce any variance in results?

[@azmanfc]

How can I use cubeset but i want the members only list after the first filtering, that mean, i the same data, i main group before smaller group,