Forum Discussion
Need Assistance Combining Row Data
Hi, I have a power bi report where the data is formatted like this Column1 Column2 Column3 Row1 Data1 Row2 Data2 ...
Hi mikekolba,
Based on my test, you could refer to below steps:
Sample data:
Create a calculated column:
Table = DISTINCT(SELECTCOLUMNS('Table1',"A",MAX('Table1'[Item]),"B",MAX('Table2'[Item_1]),"C",MAX('Table3'[Item_3])))
Result:
You could also download the pbix file to have a view.
Regards,
Daniel He
Thanks Daniel. I'll take a look and see if it does what i need and let you know.
Mike