Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Unpivoting regular column,calculated column and calculated measure in one table

Hello All,

I have a set of data as below:-

c1.PNG

I do some calculations over this and end up with below set of data :-

c2.PNG

Where in OVRCOUNT1,OVRCOUNT2,OVRGOOD1,OVRGOOD2 are all calculated columns.

Furthermore I create calculated measure as below:-

c3.PNG

Where in COUNTPCT and GOODPCT are calculated measure.

I want to unpivot all these fields into one :-

c4.PNG

 

I know this is a kind of unpivoting work but I am not sure how it can be done among regular columns, calculated columns and calculated measure altogether.

Can someone help me with this, it would be a great help to me!

 

Thank You in Advance! 

1 ACCEPTED SOLUTION
v-chuncz-msft
Community Support
Community Support

@Anonymous ,

 

You may try UNION Function to add a calculated table.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-chuncz-msft
Community Support
Community Support

@Anonymous ,

 

You may try UNION Function to add a calculated table.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.