PP10 | Convert Pivot Table to Sheet Formulas | CUBEMEMBER&CUBEVALUE functions | Power Pivot tutorial

#excel #exceltutorial #powerpivot #dax
---------------------------------------------------------------------
Visit the website: www.aaa-power.net
---------------------------------------------------------------------
Chapters:
0:00 Intro
1:34 Convert a Pivot Table into Sheet Formulas
4:22 Change report layout and format
8:12Update formulas with the new data added!!
9:24 Add slicers and charts to the report!!
12:55 Retrieve data directly using CUBEVALUE Function
---------------------------------------------------------------------
To watch the full Playlist
• PP: Power Pivot Tutorial
---------------------------------------------------------------------
To watch PQB: Power Query Basics Series:
• PQB :Power Query Basics
---------------------------------------------------------------------
To watch PT: Pivot Tables Series:
• Excel Data Analysis: P...
---------------------------------------------------------------------
To download the working files:
drive.google.com/drive/folder...
---------------------------------------------------------------------
To subscribe:
/ @aaaexcelenglish
---------------------------------------------------------------------
To follow on Facebook:
/ excelispower
---------------------------------------------------------------------
To follow on LinkedIn:
/ amratef

[@alexrosen8762]

Very useful tutorial. Thanks a lot 🙏

[@aaaexcelenglish]

Most welcome 🙏

[@jawadahmadehssan6251]

Great tip. Thank you

[@aaaexcelenglish]

My pleasure dear

[@roywilson9580]

Thanks for publishing the video. Cube functions are so useful and they are not as difficult as they at first seem once you get used to the syntax used. I think that anyone who can produce the DAX required for a data model should easily be able to learn how to use Cube functions. Learning them is a must as they have many powerful applications in reporting. Once again thanks for uploading a video on this often ignored functionality.

[@aaaexcelenglish]

Hello, thank you for following my channel and for your comment, I do agree, it looks a bit complicated, but once you get used on it, it can facilitate a lot of reporting work

[@user-ys2gb6vl7t]

This one is so deep. But worthy spending time to learn. My only worry is when i go this far with the data model, i always have to make sure that the results of measures are correct. Since I don not have much practices, i Hope my suspicions will fade away once i used to work with more & more data models in the future.

[@aaaexcelenglish]

Absolutely correct, your worries will go away with practice and double checking results. I also recommend that you start with simple measures at the beginning, the you take one step at a time.