Contents tagged with Power Query
-
Power Query Pivot Swap
I recently was given a CSV file that listed users and the groups they belonged to, from an Active Directory dump.
-
Power Query for Azure tables and updating column names
I recently did some PowerBI work using Azure Table Storage. In the query editor, it seemed that each table I pulled in from Azure Tables had a very similar process.:
-
Power Query function for dense ranking
Recently I was having issues writing a measure in DAX to rank items properly (not an issue with the DAX, but in my understanding of the DAX).
-
Power Query to Promote Headers and removing Special Characters
I had an Excel spreadsheet that had "nicely" formatted column headers that made the text appear on separate lines (ie. the text included Alt-Enter linefeeds). I wanted to use it as a source for Power Query (and PowerBI), but remove the linefeeds in the names before promoting them to the column header.