Forum Discussion
List in query to column
Hello,
I have following query. The last column contains a list with dates.
I now want the list in a new table togetther with the index.
Each row has multiple dates, I need a table with all dates for all the indexes.
Or is there a possibility to expand my current table / query with all te dates from the lists?
Dirk_Kuypers I believe that you want to right click your query and choose Reference. Then select your Index and List futur dates columns and remove your other columns. Then just expand your List futur dates column using the diverging arrows in the column header.
4 Replies
Dirk_Kuypers I believe that you want to right click your query and choose Reference. Then select your Index and List futur dates columns and remove your other columns. Then just expand your List futur dates column using the diverging arrows in the column header.
Dirk_Kuypers Hmm. So you can get to the point where you create the new query then and all looks good in the Preview area in Power Query Editor? Perhaps make sure that your List futur dates column is set to be a Date and not an integer? Hard to say exactly. Any chance you can post your PBIX file to something like OneDrive and share a link?
Greg_Deckler , I found the problem. There was a table in the reference with the wrong data type. After fixing that, everything worked.
Thanks
