Forum Discussion

TM_Evan's avatar
TM_Evan
Icon for Helper I rankHelper I
9 years ago

Creating a table with multiple values filtered from same table

I have a table where the Loan Number for multiple sources reside on the same table.  The field which differentiates it is the Type Column.  I already created a column for each loan number (Owner Loa...
Need Help
Show and Tell
dkay84_PowerBI's avatar
dkay84_PowerBI
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

I'm having a hard time following what you describe, but just from looking at your demo data, you are trying to pivot the Number field by RootId# so that for every RootId# you have 3 columns? 

TM_Evan's avatar
TM_Evan
Icon for Helper I rankHelper I
9 years ago

What I am attempting to do is pivot the number field with the Type so that the 2 of the 3 Number types will display on the single rootId#.

 

I did manage to add a SQL data source using a SQL query with a degree of success.  Only thing with this was that I was only able to Import vs DIrectQuery.  So I am definitely getting closer to my solution.

 

I really appreciate all of the feedback since it is growing my knowledge greatly.