Forum Discussion
Helper ICreating a table with multiple values filtered from same table
Helper IDesired Result
Order Number Owner Loan Product Loan
Order Number 12345 3456
Not super sure if this will work in your particular scenario, but the "Pivot Column" button under Edit Queries does exactly what ur asking.
- TM_Evan
Thank you Scottsen for replying to this post. I am still relatively new to Power BI and the suggestion you made is something I have never even considered. I did try it today with no success unfortunately with error messages stating my data is nested.
The solution I am going for is more along the lines of DAX expressions. I am also realizing that I will need to do calculated columns in a table where I only have 1 unique root id. I unfortunately keep getting errors - ' A table of multiple values was supplied where a single value was expected.'
Funny thing is if I look at the raw data of table B (Where the loan data is, for the one unique root ID we have 3 rows for each of the 3 loan numbers suppled. My 1 column is only providing the logic to return 1 of them.
Here is the DAX statement used.
OwnerLoan = CALCULATE(VALUES('pfm B'[Number]),Filter('B','B'[Type] = 2 && 'A'[RootId#] = 'B'[RootId#]))
Yes Evan the Pivot Column option would serve you well if you were wanting to create the columns within your original table. You would use Type as your pivot column and Number as Values.
If you want the information in an additional table, that expression should work.
You might also try 'summarizing' your table under the Modeling tab. You would create a New Table and the expression would be = SUMMARIZE('Name of your Table', 'Name of your Table'[RootID#]). Then create the 3 columns bringing in the Number by filtering by Type and RootID.
