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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
lmilley
Frequent Visitor

I would like two versions of the same table

I usually work with horizontal or flat files so the data is mostly in columns. This time I brought data in that is row based so each row has only one measure. This works for some of the visualizations I want to do but sometimes not. Can I create a copy of my row based table that moves all the values into columns except for say the date field and one other and then use that version for some of the visualizations in the same desktop report? I want the file to behave like this: when I refresh the data, it refreshes the source data (and any transformations) and then I can manually our automatically refresh the horizontal version which is also a power query of sorts that has created this second table? 

 

Broader context: I usually don't have the need for FACT and DIMENSION tables and have not been fussed with that. If there is an efficient way to use row based data going forward I will consider it. I would gladly read up on it if anyone has some really good practical sources with examples and not just theory. 

 

thanks in advance!! 

 

 

1 ACCEPTED SOLUTION
CoreyP
Solution Sage
Solution Sage

Posting some example data would be helpful, but based on what you said, in Power Query you can right click your table and select duplicate. This will create a 2nd query which is a copy of your table. Then you can transform it however you like. Typically, transforming rows to columns or vice versa is done with pivot and unpivot transformations.

View solution in original post

2 REPLIES 2
CoreyP
Solution Sage
Solution Sage

Posting some example data would be helpful, but based on what you said, in Power Query you can right click your table and select duplicate. This will create a 2nd query which is a copy of your table. Then you can transform it however you like. Typically, transforming rows to columns or vice versa is done with pivot and unpivot transformations.

Thank you so muchl I will try that. 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.