Convert Flat List to Table in Power BI Pivot Without a Set Key Column Using Power Query
The scenario I am explaining today is a very specific use case, However, I have seen examples similar to this happens very often. It happens that you get a text or Excel file with values written in a flat list structure, and that needs to be changed to a table format. Usually, this process can be done using PIVOT transformation in Power Query, however, sometimes, there is no key column to use for this operation, and the process is a bit more challenging. Let's look at this example and see how this can be solved.
Download the sample file plus links to study more from my article here:
https://radacad.com/convert-flat-list...
*******************
Want to learn about Power BI or AI? or take your Power BI and AI knowledge to the next level for building reports? Check out our courses in RADACAD Academy for all aspects of Power BI and AI.
RADACAD courses: https://learn.radacad.com
Become an academy member: https://learn.radacad.com/product-cat...
*******************
********
CONNECT with US!
********
-- / radacad_com
-- / rad_reza
-- / leila_etaati
-- / radacad
-- / 6393399
-- https://radacad.com
********