![]() ![]() Instead, I'd recommend concatenating the fields 'Office Id' and 'Project Id' to give you a unique value. This is not optimal for performance reasons. I will say though, this will expand your table into a very large width. If I understand your request correctly, you'll want to 'Pivot Column' of those 'Office Id' column. ![]() ![]() When the editor opens up, select the 'Transform' tab and you'll see the options of 'Pivot Column' or 'Unpivot columns' in the 'Any Column' section.On the 'Home' tab, click the 'Edit Query' button.So there are a couple of ways to create a unique row, but your goal of 'pivoting' the table should rely not on DAX but the M and the Query Editor. I would like to "pivot" this data so there is one row per Site Name and the Client(s), Operator(s) and Main Contractor(s) are separate columns. As mentioned the Site Name is what each row relates to, however I have multiple rows relating to the Client(s), Operator(s) and Main Contractor(s) the Office Name Column identifies these. I have one row per office name.Īpologies the data source was in my one drive I have now imported it as an excel file so should be able to access it. The key column is an office name I then have multiple rows for client, main contractor and operator relating to this office name that I want to show as columns NOT rows i.e. I have a table that contains multiple columns with multiple values and I need to format it into a "key value" from the first column with multiple columns made from the values in the second column. If there is something that I am missing here, please upload some sample of how you want the result to look like. Please let me know, if I have not understood your problem. You can use the calculated column in the table view and use DAX to create the key column as well, but then you wont be able to Pivot the columns, which is why you need to use the query editor. This will turn all individual items in the key column into columns. Using 'columns from examples' should make it easy for you.Īfter that you can use the 'Pivot columns' after selecting the new key column and whatever column you want to pivot it by. However, you can use the query editor to create the key column and put in whatever items from the rows that you want. I saw your file but was unable to edit the query due to some credentials issue. Subject: Multiple Rows into Multiple Columns ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |