I’ve seen this in various places including Ken Pul’s blog. I wasn’t able to create a solution without rereading it so I need to practice this in detail.
Post Category → Power Query
Transpose & Unpivot
Why did I struggle to transpose & unpivot data in power query? I missed a couple of key concepts. I need to practice!
Reorder Columns
I didn’t realize reordering columns in Power Query could be so complicated. Thanks to Gil Raviv for his solution.
Linear Interpolation
I created a solution for linear interpolation in Power Query. Optimal? Definitely not but it works!
Repeating Rows to create sample data
Contoso seems to be the standard Power BI sample data-set. However, I find it helpful to use a smaller data-set when learning a concept.
Create Rows From Each Row
Each row has Start and End dates. We need to create rows for dates within each date range and split the Amount into those rows.
Rename Columns Based on Position
In Power Query I select columns based on their name, unpivot other columns and load the data into the data model. Later, if the source columns get renamed, I get an error when I refresh the query.