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

How to keep duplicate data to new table?

Hi all,

 

I've got a query data with duplicate values and I want to start to create new table with same column of query.

How do I keep and copy same column in a new table?

 

For example, there is a query like below and I want to make new table start with column of "Module ID" keeping all duplicate values.

Site NameSMP StatusModule ID
AYet_To_Start1
CYet_To_Start3
CYet_To_Start3
FYet_To_Start7
FYet_To_Start7
BYet_To_Start2
BYet_To_Start2
WYet_To_Start6
WYet_To_Start6
QYet_To_Start9
QYet_To_Start9
DYet_To_Start8
DYet_To_Start8
1 ACCEPTED SOLUTION
Fowmy
Super User
Super User

@Anonymous 

I created an additional query which will be dynamically updated as new data get uploaded. File attached below.

Fowmy_0-1702884800772.png

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

2 REPLIES 2
Fowmy
Super User
Super User

@Anonymous 

I created an additional query which will be dynamically updated as new data get uploaded. File attached below.

Fowmy_0-1702884800772.png

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Anonymous
Not applicable

Thank you!

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.