Forum Discussion

zahidah_mabd's avatar
zahidah_mabd
Icon for Helper I rankHelper I
4 years ago
Solved

Create new table by selecting specific columns and filter.

Hello,    I have a problem with creating new tables from different existing tables. So I have 2 tables 'Position' and 'Employee' which are connected thru [Staff ID] column. The relation is many-...
Need Help
  • zahidah_mabd's avatar
    zahidah_mabd
    4 years ago

    So far, the only solution I can find is to merge the two tables in the power query into a new combined table and then I expand the columns that I want from the 2nd table. 

v-chenwuz-msft's avatar
v-chenwuz-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi zahidah_mabd ,

 

Can you share your pbix file without sensitive data and expect reseult even if they are hand-drawn?

 

Best Regards

Community Support Team _ chenwu zhu

 

zahidah_mabd's avatar
zahidah_mabd
Icon for Helper I rankHelper I
4 years ago

This is my pbix file
https://www.dropbox.com/s/iy4uczif6jdrcr0/Test.pbix?dl=0

 

this is the desired output:



So basically there will be more types of data issue like missing Location etc and I will create a new separate table for each data issue with the same column fileds as the one above. and then I wil combine all data issue datables into a big table using UNION function.