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…
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…
In this demo-packed presentation on Business Intelligence, Imaginet will show you Microsoft Power BI and how it can quickly provide insights into your data so that you can realize the ‘Data Dividend’ in your organization. Find out how Imaginet can help you cash in on the untapped value of the data you already have using Microsoft Power BI. — Imaginet is your trusted technology partner who turns your business innovation ideas into reality. 18+ years…
©1997–2022 Imaginet. All rights reserved. Privacy Policy | Cookie Settings
