topic how to pull values from multiple rows with same identifier into another table in DAX in DAX Commands and Tips

how to pull values from multiple rows with same identifier into another table in DAX

WTAS80486 — Mon, 17 Apr 2023 13:52:11 GMT

Hi,

I have a table

And i wanted to pull the rows as columns into another table in DAX

I am able to pull values with category='MAIN' but the problem is how to pull all the rows with category SUB as sub number 1, sub number 2, sub number 3, sub number 4 as columns in second table. . .

Thanks!

Re: how to pull values from multiple rows with same identifier into another table in DAX

lbendlin — Thu, 20 Apr 2023 02:27:05 GMT

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523