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.
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?
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?
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.
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?
![Excel PRO TIP: Monte Carlo Simulation | Udemy Instructor, Chris Dutton [Udemy Best Seller]](/img/n.gif)
Because I was amaze for the brilliance of the content I hit the like and subscribe button. Thank you.
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.
Wow. Great. Learnt new thing today
Thank you so much!
Would you able to use if statements in conjunction with the cube functions?
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
Cube functions should be much more popular, given how powerful they are
Where can I find the video where you built the measures.
Great fantastic keep it up and thanks
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?
Excelent, Excelent & Excelent. Thanks for sharing
Where can we download the file u are using in the video? without the video is useless
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?
This is really amazing..better than getpivot and all
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.
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,
Complex but useful
How can I display a CUBEVALUE including more than a single CUBEMEMBER? Let's say Transactions of Silver & Golden together?
Nice video! Could I use references with ?, * signs?
Awesome.
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?