Tag

power query Archives ⋆ Imaginet

Power Query Function for Dense Ranking

By All Posts, Power BI & SQL, Tutorials No Comments

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). I did some searching and came across Chris Webb’s article that had a nice implementation of ranking using Power Query. The technique he proposed uses Power Query to: sort a table by the column you want to rank by, add an index column…

Read More

Power Query for Azure tables and Updating Column Names

By All Posts, Azure, Power BI & SQL, Tutorials No Comments

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.: Get the list of tables available for the storage account. Select a table Select the Content of the table (excluding the RowKey, PartitionKey, and timestamp columns) Expand the columns in the Content Rename the columns Azure…

Read More
Let‘s Talk.
  • Let's Talk

  • This field is for validation purposes and should be left unchanged.