Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Search instead forย 
Did you mean:ย 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Anonymous
Not applicable

Transform table in power BI

โ€Ž06-02-2022 07:39 PM

What would be the DAX formula to use to transform the table below?

Gill_Phang_0-1654223639540.png

 

Message 1 of 3
316 Views
0
2 REPLIES 2
Samarth_18
Community Champion
Community Champion

โ€Ž06-02-2022 10:45 PM

Hi @Anonymous ,

 

With the help of pivot and unpivot you can achieve it. Please refer the attached file.

 

https://radacad.com/pivot-and-unpivot-with-power-bi 

 

Output:-

Samarth_18_0-1654235097633.png

 

BR,

Samarth

 

Best Regards,
Samarth

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin

_pivot_unpivot.pbix
Message 2 of 3
277 Views
0
Anonymous
Not applicable
In response to Samarth_18

โ€Ž06-02-2022 11:02 PM

Hi @Samarth_18 

 

Thanks for your suggestion. But I can't use this because the values are formularised and linked to other tables in Power BI. When I unpivot and pivot again, it only reflect the changes for Grade, not the values.

Message 3 of 3
272 Views
0

Helpful resources

Announcements
November Fabric Update Carousel

Fabric Monthly Update - November 2025

Check out the November 2025 Fabric update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All
Users online (27)