Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, I'm very new to Power BI.
I'm trying to create a Matrix that extracts the below Excel data and outputs to the following table, so I can create a few visual graphs from the 2nd table.
Would really appreciate someone to guide me please as I'm a beginner. Thanks in advance !
Solved! Go to Solution.
Hi @Dante79,
Please follow this link. Hoping you wil get solution of your problem.
https://community.powerbi.com/t5/Desktop/Merged-Cells-in-Source/td-p/194473
If any concern revert me back.
Best Regards,
Ravi
Thanks for your prompt reply !
I tried some of the steps in the link and managed to merge the columns into one but still can't figure out how to achieve the output table view that I desired.
Thanks Ravi !
You've been a great help ! Really appreciate the gesture to do a video call to teach me step-by-step too. Two thumbs up !